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

Reading files with some fields occupying two or more rows

When you use one of the Kettle steps devoted for reading files, Kettle expects one entity per row. For example, if you are reading a file with a list of customers, then Kettle expects one customer per row. Suppose that you have a file organized by rows, where the fields are in different columns, but some of the fields span several rows, as in the following example containing data about roller coasters:

Roller Coaster Speed Location Year Kingda Ka 128 mph Six Flags Great Adventure Jackson, New Jersey 2005 Top Thrill Dragster 120 mph Cedar Point Sandusky, Ohio 2003 Dodonpa 106.8 mph Fuji-Q Highland FujiYoshida-shi 2001 Japan Steel Dragon 2000 95 mph Nagashima Spa Land Mie 2000 Japan Millennium ...

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