PLEASE NOTE: This documentation applies to an earlier version. For the most recent documentation, visit 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