Skip to content

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