Transpose Rows
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).
In Snowflake environments, this component concatenates each value into a delimited string in the output. You could then use a Split Field component after the Transpose Rows component to convert the delimited strings into a set of new columns, if required.
In Databricks environments, this component returns values as Databricks ARRAY <String>
types. Note that these values can't be manipulated by a Split Field component as described above for Snowflake.
Note
Use the Transpose Columns component if you want to map sets of input columns into new output columns.
Properties
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're 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.
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're 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.
Snowflake | Databricks | Amazon Redshift |
---|---|---|
✅ | ✅ | ❌ |