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