ArrayAgg
ArrayAgg joins a given column's row values into a single array (eg ["apple", "cherry", "banana"]). Each group of values within a column will be aggregated into an individual array.
Requirements
- This function is only available for Snowflake connections.
Usage
ArrayAgg(value)
value (required) The column of values that you would like to combine.
Usage Tips
- Sorting: Sort the initial input column of values to subsequently sort the resulting aggregated array. If no sort is applied to the initial column, the resulting array's order of values will be unpredictable.
Example
ArrayAgg([Email])
Within each [Company] group, values from the column [Emails] are aggregated into an array of emails.