Array functions overview

Sigma's array functions manage and manipulate arrays, or lists of homogenous values.

ArrayContains
Determines if the array (or list) contains the specified value; True or False.
ArrayDistinct
Returns the array without duplicate values.
ArrayLength
Determines the number of entries in an array, or list.
ArraySlice
Returns a portion of an array, defined by the starting index and length.

The following Window function also operates on arrays:

ArrayAgg
Aggregates a column's row values into a single array; one result for each window.

Was this page helpful?
Yes No