Let's continue working with the football matches file. Suppose that you want to take that information to obtain some statistics, for example, the maximum number of goals per match in a given day. To do this, follow these instructions:
Create a new transformation, give it a name and description, and save it.
By using a Text file input step, read the
matches.txtfile, just like you did it in the previous section.Do a preview just to confirm that the step is well configured.
Add a Sort rows step to the transformation, and sort the fields by
regionandmatch_datein ascending order.Expand the Statistics category of steps, and drag a Group by step to the canvas. Create a hop from the Sort rows step to this new step.
Edit the Group by step and fill in the configuration window as shown in the following screenshot:
When you click on the OK button, a window appears to warn you that this step needs the input to be sorted on the specified...