Skip to content

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


ExpressionDescription
ExpressionA placeholder in a function replaced with the actual widget and measure names.
Widget NameThe specific name or identifier of the widget used for data visualization.
MeasureThe name of the measure displayed or analyzed using the widget.

Write the CONCATNATE function

CONCATNATE(<expression>)
  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 section.

CONCATNATE in Calculated Columns

ExpressionDescription
ExpressionA placeholder in a function that is replaced with the column names.
Column NameThe name of the column in the dataset or Datasource containing the values.

Write the CONCATNATE function

CONCATNATE(<expression>)
  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 section.