---
title: CONCAT
description: Learn how to use the CONCAT function to combine column values, create calculated columns, and enhance data visualization by merging text, numbers, or dates effectively.
---
import { Aside, Steps } from '@astrojs/starlight/components';

# CONCAT

The CONCAT function in Infoveave is used to combine values across columns (row-wise).

## Applicable to

* Calculated Columns
* Expressions

## Return Value

The return value of the CONCAT function is a single string that results from concatenating the values in a column.

## Remark

CONCAT function can be used across Dates, Text, and Numbers.

## Syntax

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

## CONCAT in Board Expression


<Aside>
Expressions help you add visual effects to your dashboard through widget-specific conditions. It is important to note that the Expressions are not meant to manage or modify data.
</Aside>



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


 Write the CONCAT function. For instance

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

## CONCAT in Calculated Columns



| 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 that contains the values you want to analyze. |


Write the CONCAT function. For instance

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

## Example

**Objective** Consider that you have the below dataset, your goal is to combine the FIRST and LAST name to get the CUSTOMER NAME.

| FIRST NAME | LAST NAME |
|---|---|
| John | Doe |
| Alice | Smith |
| Bob | Johnson |
| Emily | Brown |
| Michael | Davis |

You can use the CONCAT function like

```
CONCAT(VALUE([FIRST NAME]), " ", VALUE(LAST NAME))
```

The new calculated column "CUSTOMER NAME" will combine the FIRST and LAST name.

| FIRST NAME | LAST NAME | CUSTOMER NAME |
|---|---|---|
| John | Doe | John Doe |
| Alice | Smith | Alice Smith |
| Bob | Johnson | Bob Johnson |
| Emily | Brown | Emily Brown |
| Michael | Davis | Michael Davis |


<Aside>
You can also use the ampersand (&) sign to combine two or more values in multiple columns to a single value.

```
VALUE([FIRST NAME]) &" "& VALUE(LAST NAME)
```
</Aside>