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.
concatenateColumns:
resultColumn: "<insert column name>"
separator: "<insert separator character (optional)>"
columns:
- "<insert name of source column>"
- "<insert name of source column>"