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:
    Time for action—calculating the top scores with a subtransformation
  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 ...

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.