ArrayAgg

The ArrayAgg function identifies non-null row values in a column or group and aggregates them into a single array.

Syntax

ArrayAgg(value)

Function argument:

value	(required) The column containing values to join.

Example

ArrayAgg([County Name])

For each grouping (grouped by state name) the ArrayAgg function returns an array containing non-null values from the corresponding rows in the County Name column.