Pentaho Data Integration Beginner's Guide

Time for action – aggregating football matches data with the Row Denormaliser step

Let's now work with the football matches files that you came across in Chapter 2, Getting Started with Transformations, and Chapter 3, Manipulating Real-world data.

In this tutorial, we will calculate the total and average number of goals converted in a match date-wise. You will calculate the numbers for both the USA and for Europe.

1. Create a new transformation.
2. Read the football matches files just as you did in the tutorials of Chapter 2, Getting Started with Transformations, and Chapter 3, Manipulating Real-world data. This time, however, we will add a new field. In the Text file input configuration window select the Additional output fields tab.
3. In the Short filename ...