O'Reilly logo

Pentaho 3.2 Data Integration Beginner's Guide by María Carina Roldán

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required