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 ...