Let's forget the examinations for a while, and retake the World Cup tutorial from the previous chapter. The file you obtained from that tutorial was a list of results of football matches. These are sample rows of the final file:
Match Date;Home Team;Away Team;Result 02/06;Italy;France;2-1 02/06;Argentina;Hungary;2-1 06/06;Italy;Hungary;3-1 06/06;Argentina;France;2-1 10/06;France;Hungary;3-1 10/06;Italy;Argentina;1-0 ...
Now you want to take that information to obtain some statistics such as the maximum number of goals per match in a given day. To do it, 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
wcup_first_round.txt
file you generated in Chapter 2. Give the name and location of the file, check the Content tab to see that everything matches your file, and fill the Fields tab.Do a preview just to confirm that the step is well configured...