Page Operations
Browse SpaceDescription
The Field splitter step allows you to split fields based on delimiter information.
Options
The table below contains options configuring the Field splitter step:
| Option | Description |
|---|---|
| Step name | Name of the step; this name has to be unique in a single transformation |
| Field to split | The name of the field you want to split |
| Delimiter | Delimiter that determines the end of a field |
| Fields table | This table is where you define the properties for each new field created by the split. For each new field, you must define the field name, data type, and other properties. |
Examples
Below are examples of split fields:
Example 1
SALES_VALUES field containing: "500,300,200,100"
Use these settings to split the field into four new fields:
- Delimiter: ,
- Field: SALES1, SALES2, SALES3, SALES4
- Id:
- remove ID no, no, no, no
- type: Number, Number, Number, Number
- format: ###.##, ###.##, ###.##, ###.##
- group:
- decimal: .
- currency:
- length: 3, 3, 3, 3
- precision: 0, 0, 0, 0
Example 2
SALES_VALUES field containing "Sales2=310.50, Sales4=150.23"
Use these settings to split the field into four new fields:
- Delimiter: ,
- Field: SALES1, SALES2, SALES3, SALES4
- Id: Sales1=, Sales2=, Sales3=, Sales4=
- remove ID yes, yes, yes, yes
- type: Number, Number, Number, Number
- format: ###.##, ###.##, ###.##, ###.##
- group:
- decimal: .
- currency:
- length: 7, 7, 7, 7
- precision: 2, 2, 2, 2