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"