Sigma's array functions manage and manipulate arrays, or lists of homogenous values.
Determines if the array (or list) contains the specified value;
Returns the array without duplicate values.
Determines the number of entries in an array, or list.
Returns a portion of an array, defined by the starting index and length.
The following Window function also operates on arrays:
Aggregates a column's row values into a single array; one result for each window.
Updated 2 months ago