concatenate(*columns: column, {
    "param": value,
    ...
}) -> (result: column)

If only a single input column is provided, even if it is a list, the result will be a text column by default.

If multiple columns are passed, and any of these contains lists, then the result is also a column of lists. In this case, each output list will contain the result of concatenating all elements in the corresponding row, whether these elements are themselves lists or not.

If none of the multiple input columns contains lists, the result will be a text column. Each input column will be converted to a string representation if necessary, and then concatenated with a given separator and pre- and/or postfix.

You can change this default behavior by explicitly setting an out_type in params.

concatenate(*columns: column, {
    "param": value,
    ...
}) -> (result: column)
​
separator
[string, null]

A separator to use between elements of individual columns when concatenating as texts.

​
prefix
[string, null]

A prefix to prepend to the result of the concatenation (or to a single column if no more were provided).

​
postfix
[string, null]

A postfix to append to the result of the concatenation (or to a single column if no more were provided).

​
nan_as
[string, null]

How to represent missing values (NaN) in the concatenated result. If a “nan_as” value is specified, this will be used to fill in missing values during concatenation. With "nan_as": null the concatenation will produce a missing value in rows where at least 1 column to be concatenated had a missing value.

​
out_type
[string, null]

The semantic data type of the output column. Note, if this type is not compatible with the result of the concatenation, the output may consist of missing values (NaNs) only.

Values must be one of the following:

category date number currency url boolean text list[category] list[date] list[number] list[currency] list[url] list[boolean]

Was this page helpful?

Suggest edits