PLEASE NOTE: This documentation applies to Pentaho 8.1 and earlier. For Pentaho 8.2 and later, see Row Flattener on the Pentaho Enterprise Edition documentation site.
Description
The Flattener step allows you flatten data sequentially.
Options
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 |
Example
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: