Text
Merge Columns
Joins two or more columns into a single new column with a separator, removing the originals.
When to use it
Use it to build a full name, an address line or a composite key from parts that arrived in separate columns.
In a pipeline
File InputMerge ColumnsExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Columns to Merge (in order) | select | Yes | Select column... |
| Separator | text | — | |
| New Column Name | text | — | merged |
Example
Combine first and last name
- Columns to Merge (in order)=First Name, Last Name
- Separator=(space)
- New Column Name=Customer
| First Name | Last Name | Order |
|---|---|---|
| Mia | Osborn | A-1 |
| Leo | Park | A-2 |
| Order | Customer |
|---|---|
| A-1 | Mia Osborn |
| A-2 | Leo Park |
First Name and Last Name are consumed and the merged column is added at the end of the row.
Worth knowing
- The source columns are removed; use Calculated Column instead if you need to keep them.
- Fewer than two column names leaves the rows untouched.
- Values are merged in the order of the dropdowns, not in the order they appear in the table; use Add column for a third part.
- Missing cells contribute an empty string, which can leave a stray separator.