Split Fields To Rows
Description
Split fields to rows, is a step in the Transformation Plugin for Process Studio Workflows. This step allows you to split a row containing a delimited field into multiple new rows, one per split value. The original field must be a string field. A new field name must be specified. If the value type/format of the new row is not specified, the new f ield will use the same type/format as the original field.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| 2 | Field to split | The field you want to split |
| 3 | 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]. |
| 4 | New name field | The name of the new field |