ArrayAggDistinct
The ArrayAggDistinct function identifies distinct non-null row values in a column or group and aggregates them into a single array.
This function isn't compatible with all data platform connections. To check if your connection supports it, see Supported data platforms and feature compatibility.
Syntax
ArrayAggDistinct(value, [direction])
Function arguments:
value | (required) The column containing values to join. |
direction | (optional) The directional order to sort the column values.
When a direction isnβt specified, Sigma sorts values in the same order as the column referenced in the value argument. If the referenced column isnβt sorted, Sigma sorts values in ascending order by default. |
Example
ArrayAggDistinct([Product Type], βascβ)
For each grouping (grouped by order number) the ArrayAggDistinct function returns an array containing distinct non-null valuesβsorted in ascending orderβfrom the corresponding rows in the Product Type column.
Updated 25 days ago