documentationconcat_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 |
Constant |
|---|---|---|---|---|
str |
string |
Required |
Can be multiple |
Variable |
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)