Hitachi Vantara Pentaho Community Wiki
Skip to end of metadata
Go to start of metadata

(warning) 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:

  • No labels

2 Comments

  1. user-54573

    Is there a way to flatten data based on a key/id field. For example, if I have a one-many table, say product and product_features where product_features.id = product.id and a product can have varying number of features, is there a way to flatten both of these into a format such as feature_1, feature_2, feature_3,....

  2. user-f3c88

    Raj

    See the Row Denormalizer step