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.
Create a new transformation.
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:
With a Select values step, keep only the following columns:
Country
,Performance
, andtotalScore
.With a Sort Rows step sort the data by
Country
ascendant.After the Sort Rows step, put a Row denormalizer step.
Double-click this last step to configure it.
As the key field put
Performance
, and as group fields putCountry
.Fill the target fields' grid like shown:
Close the window.
With the Row denormalizer step selected, do a preview. You will see this: