Join Columns

This Join Columns Step is used to combine multiple columns into a single column, using a specified delimiter and qualifier. It is the reverse of the Split Columns Step.

Key Features

1. Combine Columns: Merge the values of selected columns into a single field.
2. Use Delimiters: Specify a delimiter (e.g., comma, space, or custom characters) to separate the joined values.
3. Add Qualifiers: Optionally include qualifiers (e.g., quotes) around the joined values for added clarity or formatting.
4. New Field Creation: The resulting combined column is added as a new field at the end of the data block.
5. Hide Original Columns: The original columns used for the join are hidden to keep the dataset tidy.

This step is particularly useful for consolidating data into a single column for reporting, exporting, or simplifying downstream processing.