Split Fields To Rows

Description

Split Fields To Rows splits a delimited string field into multiple new rows, creating one row for each value found in the delimiter-separated string. Use this step when a single field contains multiple values that should be processed individually — for example, expanding a comma-separated list of email addresses into separate rows, or converting a multi-value tag field into individual records. Unlike Split Fields (which creates new columns), this step creates new rows, which is useful for normalizing one-to-many relationships in the data.

Configurations

Field Name	Description
Step name	Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow.
Field to split	The field you want to split
Delimiter	The delimiter or separator used. Special characters (e.g. CHAR ASCII HEX01) can be set with the format $[value], e.g. $[01] or $[6F,FF,00,1F].
New name field	The name of the new field