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:
The resulting data set is shown below. For every three rows, the data is now formatted into a single row.
Note: Incomplete or non-consecutive data can lead to unexpected results.