Merge Columns

The Merge Columns transformer allows you to join multiple columns into a single column using a delimiter or any special character. for example if there two columns named country and state, You will be able to join both of the column values.

Merge columns Transform dialog is shown as below:

1. Enter Title like most of the other transforms. Ensure that the Title is uniquely identifying the step
2. Enter Description to provide further information for this particular step. This is helpful in ensuring the transform step is readable in a complex workflow, ensuring readability. This step however, is Optional.
3. New Column Name should be given for merging two columns.
4. Add a Delimiter or any special character as a middle character to merge all the columns.
5. Click Create to add the step to the recipe.