Help Centre

GETTING STARTED

INTEGRATE
- Introducing integrate
- Workspace
- Managing pipelines
- Inputs and outputs
- Join and Union
- Dates
- Automap Values
- Validation
- Operations
- Syntax and functions
- Updates and legacy

DATA

ANALYSE

TUTORIALS
- Integrate
- Analyse

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>"