O'Reilly logo

Pentaho 3.2 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 custom files by executing a transformation for every input row

Suppose that 60 is the threshold below which a student must retake the examination. Let's find out the list of students with a score below 60, that is, those who didn't succeed in the writing examination. Then, let's create one file per student telling him/her about this.

First of all, let's create a transformation that generates the list of students who will take the examination:

  1. Create a new transformation.
  2. Drag a Text file input, a Filter rows, and a Select values step to the canvas and link them in that order.
  3. Use the Text file input step to read the global examination file.
  4. Use the Filter rows step to keep only those students with a writing score below

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