Row Flattener

Row Flattener

Description

The Row Flattener transform allows you to flatten data sequentially.

Hop Engine	✓
Spark	?
Flink	?
Dataflow	?

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