Column split

The Column Split function allows you to divide the contents of one column into multiple columns based on a specific delimiter (like a comma, space, or dash) or a pattern.

This is especially useful when a single column contains combined or structured data, and you need to separate it into individual parts for easier analysis or further processing.

Example:

If a column contains “John,Smith,USA”, you can split it into:

• First Name → John
• Last Name → Smith
• Country → USA

How to use a Column Split?

Step 1: Join the Column Split component to the step.

Step 2: Open the Column Split by clicking on it.

Step 3: Choose the specific column that the user wishes to split.

Step 4: In the “Rages” field, specify the separator character that separates the data within the source column. Depending on user data format, common delimiters include commas, semicolons, tabs, spaces, pipes (|), and more.

Step 5: Add a column name by clicking the “+” icon button.

Click “Save” to proceed.

For example:

• In the “Split Column” field, we chose the “ProductName” column for splitting.
• For the “Rages” field, we utilized the “Comma” separator.
• In the “Add Column Name” section, we designated the columns as “Name” and “Type.”

Preview