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.


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.


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