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 |
---|---|---|---|---|
❌ | ✅ | ✅ | ✅ | ✅ |