Example

Suppose your file contains company order information and has one attribute per row as shown below. In the file, each order is described in three rows: one row for the name of the company, one for the country, and one for the order number:

Land of Toys Inc.
United States
10107
Lyon Souvenirs 
France
10134
Australian Gift Network, Co
Australia
10374
Gift Depot Inc.

Using the following entries in the Row flattener step, the rows are flattened into three target fields:

Row flattener entry example

The resulting data set is shown below. For every three rows, the data is now formatted into a single row.

Results example for Row flattner

Note: Incomplete or non-consecutive data can lead to unexpected results.