Skip to main content

Merge Columns

Feature Description

Merge Columns combines data from two or more existing columns into one new column, allowing related information from different columns to be displayed together.

For example, you can merge region fields such as province, city, and street into a full address, or combine year, month, and day into a complete date. This makes the dataset cleaner and creates new information for richer analysis.

Procedure

  1. Drag the Merge Columns operator from the dataflow operator panel into the canvas on the right.

  2. Click the Merge Columns operator, specify the new column name, select the original columns to merge, and click Confirm.

  3. Choose whether to Delete Original Columns as needed.

    |200

  4. Set a delimiter for the new column to define how original columns are merged.

    |300

  5. After configuration is complete, preview the result.