Pentaho Data Integration Beginner's Guide

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:
   
6. With the Row Normaliser selected, do a preview. You should ...