Function Index

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.

Examples

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.