---
title: "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."
---

# groupConcat

> Concatenates all of the values in the given column of the given dataset into a string, with each value separated by the string separator.

**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 |

```python title="Code Snippet"
groupConcat({Root Container.Table.data}, 1, " / ")  //would return the string: "380 / 120 / 125 / 322"
```
```python title="Code Snippet"
groupConcat({Root Container.Table.data}, "ProductCode", ", ")  //would return the string: "BAN_002, BAN_010, APL_000, FWL_220"
```