PLEASE NOTE: This documentation applies to Pentaho 8.3 and earlier. For Pentaho 9.0 and later, see Split Fields on the Pentaho Enterprise Edition documentation site.
Description
The Split Fields step allows you to split fields based on delimiter information.
Options
The table below contains options configuring the Split Fields 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 field. Special characters (e.g. CHAR ASCII HEX01) can be set with the format $[value], e.g. $[01] or $[6F,FF,00,1F]. |
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. |
Metadata Injection Support
All fields of this step support metadata injection. You can use this step with ETL Metadata Injection to pass metadata to your transformation at runtime.
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