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:
- Create a new transformation and read the files by using a Text file input step.
- With a Split Fields step, split the
Result field in two sections:
away_t_goals. As Delimiter use a colon (
- From the Transform category of steps, drag a Row Normaliser step to the canvas.
- Create a hop from the last step to this new one.
- Double-click on the Row Normaliser step to edit it and fill in the window as follows:
- With the Row Normaliser selected, do a preview. You should ...