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.