Pentaho 3.2 Data Integration Beginner's Guide

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:
   
3. With a Select values step, keep only the following columns: Country, Performance, and totalScore.
4. With a Sort Rows step sort the data ...