List Aggregate
This component aggregates input columns into a single output row.
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 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.
Name = string
A human-readable name for the component.
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.
Aggregations = dual listbox
The input column to aggregate.
Delimiter = string
A delimiting character used to separate concatenated values. The default is a comma.
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.
Null Replace = column editor
- Field: Select a field from the drop-down menu. This field will have any NULL values replaced by a value the user specifies in the "Replacement" column of this parameter. This may be useful for retaining the order of elements, since otherwise NULL values will not be included.
- Replacement: The value used to replace NULL values in the corresponding field (row).
Distinct Aggregations = drop-down
When "Yes", any duplicates from the selected aggregation columns are removed. Default setting is "No".
Name = string
A human-readable name for the component.
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.
Aggregations = dual listbox
The input column to aggregate.
Delimiter = string
A delimiting character used to separate concatenated values. The default is a comma.
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.
Null Replace = column editor
- Field: Select a field from the drop-down menu. This field will have any NULL values replaced by a value the user specifies in the "Replacement" column of this parameter. This may be useful for retaining the order of elements, since otherwise NULL values will not be included.
- Replacement: The value used to replace NULL values in the corresponding field (row).
Name = string
A human-readable name for the component.
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.
Aggregations = dual listbox
The input column to aggregate.
Delimiter = string
A delimiting character used to separate concatenated values. The default is a comma.
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.
Null Replace = column editor
- Field: Select a field from the drop-down menu. This field will have any NULL values replaced by a value the user specifies in the "Replacement" column of this parameter. This may be useful for retaining the order of elements, since otherwise NULL values will not be included.
- Replacement: The value used to replace NULL values in the corresponding field (row).
Strategy
This generates an aggregate query using the LISTAGG function.
| Snowflake | Delta Lake on Databricks | Amazon Redshift | Google BigQuery | Azure Synapse Analytics |
|---|---|---|---|---|
| ❌ | ✅ | ✅ | ✅ | ✅ |