concat_strings#

Description#

Return the concatenation of all string arguments. Null values are represented as empty string, i.e., “”.

Return type#

string

Domain#

This is a scalar function (calculates a single output value for a single input row.)

Categories#

Usage#

concat_strings(str_1, str_2, ...)

Argument

Type

Optional

Repeatable

Restrictions

str

string

no

yes

none

Examples#

make_col foo:concat_strings(colstr1, " ", colstr2)

Make a new column ‘foo’ that is the concatenation of ‘colstr1’, “ “, and ‘colstr2’

make_col foo:concat_strings(colstr1, ",", nullValue)

Make a new column ‘foo’ that is the concatenation of ‘colstr1’, “,”, and “”

Aliases#

strcat (deprecated), string_concat (deprecated)