Time for action – aggregating football matches data with the Row Denormaliser step
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.
- Create a new transformation.
- 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.
- In the Short filename ...