Time for action—calculating total scores by performances by country

Let's work now with the contest file from Chapter 5. You will need the output file for the Hero exercise. Fill gaps in the contest file from that chapter. If you don't have it, you can download it from the Packt website.

In this tutorial, we will calculate the total score for each performance by country.

  1. Create a new transformation.
  2. Read the file with a Text file input step and do a preview to see that the step is well configured. You should see this:
    Time for action—calculating total scores by performances by country
  3. With a Select values step, keep only the following columns: Country, Performance, and totalScore.
  4. With a Sort Rows step sort the data ...

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.