Skip to main content
Returns an array containing distinct, non-null values in a column or group. Optionally supports sorting direction. Category: aggregate Syntax: 
ArrayAggDistinct([column], |direction|)
Returns: ArrayColumn Context Filtering: ✗ No

​
Parameters

NameTypeRequiredDescription
columncolumn✓ YesThe column containing values to join.
directiontext✗ NoSorting direction. “asc” for ascending or “desc” for descending. Defaults to ascending.

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 2

​
Examples

ArrayAggDistinct([Product Type], "asc")
Returns distinct Product Type values ordered ascending as an array.
Last modified on March 13, 2026