O'Reilly logo

Pentaho Data Integration Cookbook Second Edition by María Carina Roldán, Adrián Sergio Pulvirenti, Alex Meadows

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

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