ArrayDistinct
The ArrayDistinct function returns the input array without duplicate values.
You can use the ArrayDistinct function on Snowflake, PostgreSQL, and BigQuery connections.
Syntax
ArrayDistinct(array)
The ArrayDistinct function has the following argument:
- array
- Required.
- The input array that Sigma parses to find and remove duplicates,
- Must be an array structure; to create single array from a column, use the ArrayAgg function,
Example
ArrayDistinct([Open prices array])
The ArrayDistinct function returns the following values for the Open prices array column as Distinct open prices array; note the differences in array length for each column:
