Flattener

PLEASE NOTE: This documentation applies to an earlier version. For the most recent documentation, visit the Pentaho Enterprise Edition documentation site.

Description

The Flattener step allows you flatten data sequentially.

Option	Description
Step name	Name of the step; this name has to be unique in a single transformation
The field to flatten	The field that must be flattened into different target fields
Target fields	The name of the target field to which the field is flattened

In the sample below, if you begin with the following data set...

Field1	Field2	Field3	Flatten
A	B	C	One
Z	Y	X	Two
D	E	F	Three
W	V	U	Four

The data set can be flattened to the example shown below:

Field1	Field2	Field3	Target1	Target2
A	B	C	One	Two
D	E	F	Three	Four

Below is the dialog entries used to flatten the fields: