ListAgg

Joins the values in a column into a single value. Each window of values within a column will be combined into a single list of values.

Usage

ListAgg(column, separator )

column (required) The column of values that you would like to combine.

separator (optional) The separator to use between values. If no separator is specified, a comma will be used.

Example

ListAgg([Account Owners], "-")
  • In each group, values from the column Account Owners will be combined and listed in a single row, separated by a dash.

See Also

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us