Row Flattener
DescriptionThe Row Flattener transform allows you to flatten data sequentially. |
Supported Engines
|
Options
| Option | Description |
|---|---|
Transform name |
Name of the transform; this name has to be unique in a single pipeline |
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 |