Split Rows

The Split Rows transformation command allows you to split the values of a field into two or more separate rows based on a separator. All other field values are copied to the new rows.

Configuration

After you add a Split Records ETL command to the ETL designer and connect an input to it, you need to select:

• The column you would like to split.

• The separator character to separate on.

Example

The Items_Purchased column in the source data is a comma separated list of items purchased in the order.

We used the Split Rows command to split the column values duplicating the row once for each value in the column.

After the column is split we get a record per item purchased for each order: