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 ... )

Argument

Type

Required

Multiple

str

string

Required

Can be multiple

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)