Pentaho 3.2 Data Integration Beginner's Guide

Time for action – calculating the top scores with a subtransformation

Let's modify the transformation that calculates the top scores to avoid unnecessary duplication of steps:

1. Under the transformation folder, create a new folder named subtransformations.
2. Create a new transformation and save it in that new folder with the name scores.ktr.
3. Expand the Mapping category of steps. Select a Mapping input specification step and drag it to the work area.
4. Double-click the step and fill it like this:
   
5. Add a Sort rows step and use it to sort the score field in descending order.
6. Add a JavaScript step and type the following code to filter the top 10 rows:

   trans_Status ...