---
title: CONCATENATEX
description: Learn how to use the CONCATNATEX function for combining column values with specific conditions. Discover syntax, application, and how to configure expressions for efficient data analysis.
---
import { Aside, Steps } from '@astrojs/starlight/components';

# CONCATENATEX

The CONCATNATEX function in Infoveave is used to combine the values within a specified column, considering a specified condition that filters which values are included.

## Applicable to

* Calculated Columns
* Expressions

## Return Value

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

## Remark

* CONCATNATEX function can be used across Dates, Text, and Numbers columns.
* CONCATNATEX function neglects all nulls and blank values.

## Syntax

```
CONCATNATEX(<expression>,<condition>)
```

## CONCATNATEX 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>



| Parameter       | Description                                                                                                    |
|-----------------|----------------------------------------------------------------------------------------------------------------|
| Expression      | A placeholder in a function that is replaced with the actual widget and measure names.                         |
| Condition       | A placeholder in a function that is replaced with the condition filter.                                      |
| 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.                       |
| Dimension       | Represents the dimension column that is being displayed or analyzed using the widget.                         |
| Dimension Value | Represents the specific dimension items within the dimension column used for the visualization in the widget. |


## CONCATNATEX in Calculated Columns



| Parameter          | Description                                                                                           |
|----------------------|-------------------------------------------------------------------------------------------------------|
| Expression          | A placeholder in a function that is replaced with the actual column names.                            |
| Condition           | A placeholder in a function that is replaced with the condition filter.                              |
| Column Name         | The name of the column in the dataset or Datasource that contains the values you want to analyze.     |
| Filter Condition    | A filter condition returns the data points that meet the defined condition that you want to analyze. |


Write the CONCATNATEX function. For instance

```
CONCATNATEX(<expression>,<condition>)
```
<Steps>
1. Where `expression` equals `'Widget Name'[Measure]` and `condition` equals `[Dimension Name]="Dimension Value"`.Replace **Widget Name** with the actual name of your widget, **Measure** with the required measure name, **Dimension** with the required dimension name and **Dimension Value** with the dimension value of the selected dimension name.
2. To learn how to configure an Expression in Infoveave, visit the section [Configure Expression](/insights-v8/advanced-configuration/#configuring-expressions).
3. Replace `<expression>` with required `[Column Name]` and `<condition>` equals `[Column Name]="Filter Condition"`
4. Replace **Column Name** with the actual name of your column and **Filter Condition** with the required condition to be applied on the columns.
5. To learn how to add calculated columns in Infoveave, visit the section [Calculated Columns](/studio-v8/datasources/calculated-columns-datasource/) under Sources.
</Steps>

<Aside type="caution">
Do not use double quotes when setting up a numeric as the filter condition.
</Aside>