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 – enhancing the matches file by normalizing the dataset

Now, you will convert the matches file to a format suitable for answering the proposed questions as follows:

  1. Create a new transformation and read the files by using a Text file input step.
  2. With a Split Fields step, split the Result field in two sections: home_t_goals and away_t_goals. As Delimiter use a colon (:).
  3. From the Transform category of steps, drag a Row Normaliser step to the canvas.
  4. Create a hop from the last step to this new one.
  5. Double-click on the Row Normaliser step to edit it and fill in the window as follows:
    Time for action – enhancing the matches file by normalizing the dataset
  6. With the Row Normaliser selected, do a preview. You should ...

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