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

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

If you did the previous sections successfully, you should know that you already have half the work done! The prepare_data.ktr transformation builds the list of students. If not, before proceeding, please go back and create that transformation; you will need it now.

  1. Create a new transformation.
  2. Drag to the canvas a Get rows from result step.
  3. Double-click on the Get rows from result step and use it to define ...

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