O'Reilly logo

Pentaho Data Integration Beginner's Guide by María Carina Roldán

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

Time for action – generating top average scores by copying and getting rows

In this section, we will split our work into two different transformations:

  • The first for reading the examination data and preparing it for further processing
  • The second for picking that prepared data and do some work with it

As said, you will need the same input files you've been working with. Once you have the files, you are ready for work:

  1. Open Spoon and create a new transformation.
  2. Just as you did in the previous section, define a named parameter with the name of the file to read, and read the examination file with a Text file input step.

    Note

    It's not mandatory to use the named parameter, but we do it for two reasons: first, for getting the habit of creating reusable transformations ...

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