Help Centre

Combine Columns

Combine Columns is a templated script operation creating a new column which combines (concatenates) the content of multiple other columns. Optionally, a separator character can be included between each column’s content.

Unlike the Concatenate function in Calculate, if named columns are not present, the operation will continue to function, ignoring any missing columns.


Usage

concatenateColumns:
resultColumn: "<insert column name>"
separator: "<insert separator character (optional)>"
columns:
- "<insert name of source column>"
- "<insert name of source column>"