Skip to content

Array Aggregate

The Transpose Rows component enables users to combine multiple rows into a single output row (one row for each value of the columns specified in the Groupings parameter). The component concatenates each value into a delimited string in the output.

Where required, users can use a Split Field component after the Transpose Rows component to convert the delimited strings into a set of new columns.

Users can also leverage the transformation capabilities of the Transpose Columns component.


Name = string

A human-readable name for the component.

Aggregations = dual listbox

The input column to aggregate.

Sort Order = dual listbox

Rows included in the "groupings" are ordered using this Sort Order parameter. If you are performing multiple transpositions, ordering will ensure that the items are in a consistent order.

Groupings = dual listbox

One or more source columns that form the groupings.

The output will have one row for every combination of grouping column values.


This generates an aggregate query using the ARRAY_AGG function.


Snowflake Delta Lake on Databricks Amazon Redshift Google BigQuery Azure Synapse Analytics