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 a simple file

In this recipe, you will learn the use of the Text file input step. In the example, you have to read a simple file with a list of authors' information like the following:

"lastname","firstname","country","birthyear"
"Larsson","Stieg","Swedish",1954
"King","Stephen","American",1947
"Hiaasen","Carl ","American",1953
"Handler","Chelsea ","American",1975
"Ingraham","Laura ","American",1964

Getting ready

In order to continue with the exercise, you must have a file named authors.txt similar to the one shown in the introduction section of this recipe.

How to do it...

Carry out the following steps:

  1. Create a new transformation.
  2. Drop a Text file input step to the canvas.
  3. Now, you have to type the name of the file (authors.txt) with its complete ...

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