Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4
Description
CONCAT returns the concatenation of two strings. The || operator returns the concatenation of two or more strings.
Supported input column types: STRING, INT, FLOAT. INT and FLOAT are automatically converted to strings before.
Output column type: STRING
NULL-values: If at least one value is NULL, the result of the concatenation is NULL
Syntax
CONCAT ( table.column1, table.column2 )
table.column1 || table.column2 [ || table.columnN ]*
Examples
Concatenate column values with constant string.
Query
Column1
CONCAT ("Table1"."Column1", 'Bush')
Input
Table1
| Column1 : STRING |
|---|
| 'George W. ' |
| 'George H. W. ' |
| 'John Ellis ' |
| 'Barbara ' |
Output
Result
| Column1 : STRING |
|---|
| 'George W. Bush' |
| 'George H. W. Bush' |
| 'John Ellis Bush' |
| 'Barbara Bush' |
Concatenation of 3 strings with
||.Query
Column1
"Table1"."Column1" || "Table1"."Column2" || "Table1"."Column3"
Output
Result
| Column1 : STRING |
|---|
| 'abc' |
| ' ab d' |
| '' |
| null |
| null |
| null |
| ' ' |
| '!@#&*($%^)_+x' |