Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6
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
[2] Concatenation of 3 strings with
||
.
Query
Column1
"Table1"."Column1" || "Table1"."Column2" || "Table1"."Column3"