User Manual

GETTING STARTED


OTHER EDITIONS


LAUNCHERS


MODULES


PLATFORM


APPENDIX


TUTORIALS & HELPFUL TRICKS


STRATEGIC PARTNER LINKS

Sepasoft - MES Modules
Cirrus Link - MQTT Modules

RESOURCES

Inductive University
Ignition Demo Project
Knowledge Base Articles
Forum
IA Support

ALL USER MANUAL VERSIONS

Ignition 8.1. Offline Version (04/2021)
Ignition 8 Online Version
Ignition 7.9 Online Version
Ignition 7.8 Online Version

Deprecated Pages

SDK Documentation

Employees

Sign In

Skip to end of metadata
Go to start of metadata

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.

Integer 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.

The following feature is new in Ignition version 8.1.8
Click here to check out the other new features
The following overload was introduced in 8.1.8. 

Syntax

groupConcat(collection, separator)

  • Parameters

Collection collection - The starting list, tuple, or set to use. 

String separator - What will be used to separate each of the values.

  • Returns

String - A string with every value in the specified collection separated by the separator value.


Examples

Suppose you had a table with this dataset in it:

Product CodeQualityWeight
BAN_0023803.243
BAN_0101209.928
APL_0001251.287
FWL_2203227.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".
  • No labels