CONCAT

Syntax

CONCAT(<any><any><any>  ..)

Description

Concatenates several items to one string item. Items in the function are separated by a semicolon. 

Supports more than 255 arguments.

Any data type other than the LIST type can be used with the CONCAT function.

To add elements to a list,  use the ADD function. To connect multiple lists into a single list,  use the + operator.

Examples

Connecting columns

CONCAT(#Data!Column1;#Data!Column2)

Column1Column2CONCAT returns
A

B

AB
MarkJonesMarkJones
Product6Product6

Adding specific values

CONCAT(#Data!Column1;"B")

Column1Added valueCONCAT returns
123"B"123B

CONCAT(#Data!Column1;" ";"B")

Column1Added valueAdded valueCONCAT returns
123" ""B"123 B

CONCAT(#Data!Column1;" ";#Data!Column2;" ";"B")

Column1Added valueColumn2Added valueAdded valueCONCAT returns
123" "Product" ""B"123 Product B