Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
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
types are internally automatically converted to STRING
before the concatenation is executed.
Output column type: STRING
Syntax
CONCAT ( table.column1, table.column2 )
table.column1 || table.column2 [ || table.columnN ]*
NULL handling
If at least one value is NULL, the result of the concatenation is NULL.
Examples
[2] Concatenation of 3 strings with
||
.
Query
Column1
"Table1"."Column1" || "Table1"."Column2" || "Table1"."Column3"