Pentaho 3.2 Data Integration Beginner's Guide

Time for action – generating files with top scores

In this tutorial, you will read the examination global file and generate four files—one for each particular skill. The files will contain the top 10 scores for each skill. The scores will not be the original, but converted to a scale with values in the range 0-5.

Note

As you must be already quite confident with PDI, some explanations in this section will not have the full details. On the contrary, the general explanation will be focused on the structure of the jobs and transformations.

1. Create a new transformation and save it in the transformations folder under the name top_scores.ktr.
2. Use a Text file input step to read the global examination file generated in the previous tutorial.
3. After the Text file ...