Syntax

Description

Concatenates several items into 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.

Connecting columns

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

Adding specific values

CONCAT(#Data!Column1;"B")

Column1	Added value	CONCAT returns
123	"B"	123B

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

Column1	Added value	Added value	CONCAT returns
123	" "	"B"	123 B

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

Column1	Added value	Column2	Added value	Added value	CONCAT returns
123	" "	Product	" "	"B"	123 Product B