Combine Columns

The Combine Columns command is used to combine the values of two or more columns from the command input with a separator you choose to create a new column.

Configuration

To configure a Combine Columns ETL command, you need to:

• Provide a name for the new column.

• A separator to use when combining the values: semicolon, comma, tab, space, other, or none.

• Whether you want to remove the original columns that were combined.

• The columns you want to combine and the columns to sort the output.

In the example in the screenshot, we join the first_name and last_name columns using a comma to create a new column FullName.