Split Columns

In this document, you will explore how to split columns in Astera Dataprep.   

1. To split columns in Astera Dataprep, click on the Layout option in the toolbar and select the Split Columns option from the drop-down.

1. This will open the Recipe Configuration – Split Columns panel.

1. In this panel, you can configure the following options:

• Column Name: Choose the column you want to split.

• Delimiter: Enter the character (like a space, comma, or dash) that separates the values.

• New Column Names: Specify the names for the new columns that will hold the split values.

1. Once you're done, click Apply . You’ll see in the Grid that your selected column (for example, CustomerName) has been split into new columns (like FirstName and LastName) based on the delimiter you provided.

1. Alternatively, you can right-click on a column header directly in the Grid and select Split Columns from the menu. The configuration panel will open with the selected column pre-filled. Make any changes you need and click Apply to split the column.