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
orFalse
. - 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.