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 having one field by row

When you use one of the Kettle steps meant for reading files, Kettle expects the data organized in rows, where the columns are the fields. Suppose that instead of having a file with that structure, your file has one attribute per row as in the following example:

Mastering Joomla! 1.5 Extension and Framework Development
Published: November 2007
Our price: £30.99
CakePHP 1.3 Application Development Cookbook: RAW
Expected: December 2010
Our price: £24.99
Firebug 1.5: Editing, Debugging, and Monitoring Web Pages
Published: April 2010
Our price: £21.99
jQuery Reference Guide
...

This file contains book information. In the file, each book is described in three rows: one for the title, one for the published or expected ...

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