---
title: CONCATENATE
description: Learn how to use Infoveave's CONCATNATE function to combine column values into a single string for effective data analysis.
---
import { Aside, Steps } from '@astrojs/starlight/components';

# CONCATENATE

The CONCATNATE function in Infoveave combines all column values within a single column.

## Applicable to

* Calculated Columns
* Expressions

## Return Value

A single string resulting from concatenating the values in a column.

## Remark

CONCATNATE can be used across Dates, Text, and Numbers.

## Syntax

```
CONCATNATE(<expression>)
```

## CONCATNATE in Board Expression

<br/>

<Aside>
Expressions add visual effects to your dashboard through widget-specific conditions.  They do not manage or modify data.
</Aside>



| Expression           | Description                                                                         |
|-----------------------|-------------------------------------------------------------------------------------|
| Expression            | A placeholder in a function replaced with the actual widget and measure names.      |
| Widget Name           | The specific name or identifier of the widget used for data visualization.       |
| Measure               | The name of the measure displayed or analyzed using the widget.                    |


Write the CONCATNATE function

```
CONCATNATE(<expression>)
```

<Steps>
1. Replace `<expression>` with `'Widget Name'[Measure]`.Replace **Widget Name** with your widget's name and **Measure** with the corresponding measure name.
2. To learn how to configure an Expression in Infoveave, visit the [Configure Expression](/insights-v8/advanced-configuration/#configuring-expressions) section.
</Steps>

## CONCATNATE in Calculated Columns



| Expression           | Description                                                                     |
|-----------------------|---------------------------------------------------------------------------------|
| Expression            | A placeholder in a function that is replaced with the column names.             |
| Column Name           | The name of the column in the dataset or Datasource containing the values. |


Write the CONCATNATE function

```
CONCATNATE(<expression>)
```
<Steps>
1. Replace `<expression>` with `[Column Name]`.Replace **Column Name** with your required column name.
2. To learn how to add calculated columns in Infoveave, visit the [Calculated Columns](/studio-v8/datasources/calculated-columns-datasource/) section.
</Steps>