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.
- This function is only available for Snowflake connections.
value (required) The column of values that you would like to combine.
- 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.
Within each [Company] group, values from the column [Emails] are aggregated into an array of emails.