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"