groupConcat
This function is used by Ignition's Expression language.
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, columnIndex, separator)
Parameters
DataSet dataset - The starting dataset.
int columnIndex - The index of the column to concatenate.
string separator - What will be used to separate each of the values.
Returns
- string - A string with every value in the specified column of the specified dataset separated by the separator value.
Syntax
groupConcat(dataset, columnName, separator)
Parameters
DataSet dataset - The starting dataset.
string columnname - The name of the column to concatenate.
string separator - What will be used to separate each of the values.
Returns
- string - A string with every value in the specified column of the specified dataset separated by the separator value.
Examples
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 |
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"