Pentaho Data Integration Cookbook Second Edition

Interspersing new rows between existent rows

In most Kettle datasets, all rows share a common meaning; they represent the same kind of entity, for example:

• In a dataset with sold items, each row has data about one item.
• In a dataset with the mean temperature for a range of days in five different regions, each row has the mean temperature for a different day in one of those regions.
• In a dataset with a list of people ordered by age range (0-10, 11-20, 20-40, and so on), each row has data about one person.

Sometimes, there is a need for interspersing new rows between your current rows. Taking the previous examples, imagine the following situations:

• In the sold items dataset, every 10 items, you have to insert a row with the running quantity of items ...