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 ...

Get Pentaho Data Integration Beginner's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.