O'Reilly logo

Pentaho Data Integration 4 Cookbook by María Carina Roldán, Adrián Sergio Pulvirenti

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required