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

Note

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.

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>)

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.

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>)

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.

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

Note

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)