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

Get Pentaho 3.2 Data Integration Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.