groupConcat

Description

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.

Syntax

groupConcat( dataset, column, separator )

Examples

Suppose you had a table with this dataset in it:

Product Code

Quality

Weight

BAN_002

380

3.243

BAN_010

120

9.928

APL_000

125

1.287

FWL_220

322

7.889

Code Snippet
groupConcat({Root Container.Table.data}, 1, " / ") //would return the string: "380 / 120 / 125 / 322"
Code Snippet
groupConcat({Root Container.Table.data}, "ProductCode", ", ") //would return the string: "BAN_002, BAN_010, APL_000, FWL_220"