CONCAT
Syntax
CONCAT(<any>; <any>; <any> ..)
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.
Examples
Connecting columns
CONCAT(#Data!Column1;#Data!Column2)
Column1 | Column2 | CONCAT returns |
|---|---|---|
A | B | AB |
Mark | Jones | MarkJones |
Product | 6 | Product6 |
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 |