O'Reilly logo

Pentaho Data Integration Beginner's Guide by María Carina Roldán

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required