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
| 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>)- Replace <expression>with'Widget Name'[Measure].Replace Widget Name with your widget’s name and Measure with the corresponding measure name.
- To learn how to configure an Expression in Infoveave, visit the Configure Expression section.
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>)- Replace <expression>with[Column Name].Replace Column Name with your required column name.
- To learn how to add calculated columns in Infoveave, visit the Calculated Columns section.