Aggregates / groupConcat

groupConcat(dataset, column, separator)

Concatenates all of the values in the given column of the given dataset into a string, with each value separated by the string separator. Any null values in the column are ignored.

For example, suppose you had a table with this dataset in it:

groupConcat({Root Container.Table.data}, 1, " / ")

... would return the string: "380 / 120 / 125 / 322"

groupConcat({Root Container.Table.data}, "ProductCode", ", ")

... would return the string: "BAN_002, BAN_010, APL_000, FWL_220"