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.
Create a new transformation.
Drag to the canvas a Get rows from result step.
Double-click on the Get rows from result step and use it to define two string fields: a field named
student_codeand another field namedstudent_name.Add a User Defined Java Expression step and create a hop from the Get rows from result step to this new step.
Double-click on the step and configure it as shown:
After...