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


[1] Concatenate column values with constant string.

Query
Column1
CONCAT ("Table1"."Column1", 'berry')
Input
Table1
Column1 : STRING
'blue'
'black'
'cran'
'huckle'
Output
Result
Column1 : STRING
'blueberry'
'blackberry'
'cranberry'
'huckleberry'



[2] Concatenation of 3 strings with ||.

Query
Column1
"Table1"."Column1" || "Table1"."Column2" || "Table1"."Column3"
Input
Table1
Column1 : STRINGColumn2 : STRINGColumn3 : STRING
'a''b''c'
' a''b ''d'
''''''
null'a''b'
''null'c'
nullnull'd'
''' '' '
'one''two''x'
Output
Result
Column1 : STRING
'abc'
' ab d'
''
null
null
null
' '
'onetwox'


  • No labels