Top  | Previous | Next

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:

ProductCode

Quantity

Weight

BAN_002

380

3.243

BAN_010

120

9.928

APL_000

125

1.287

FWL_220

322

7.889

 

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"