In Chapter 3, Manipulating Real-world Data, you created a file with information about football matches. The following lines of code show a variant of that file. The information is the same, and only the structure of the data has changed:
region;match_date;type;team;goals europe;07-09;home;Iceland;2 europe;07-09;away;Norway;0 europe;07-09;home;Russia;2 europe;07-09;away;Northern Ireland;0 europe;07-09;home;Liechtenstein;1 europe;07-09;away;Bosnia-Herzegovina;8 europe;07-09;home;Wales;0 europe;07-09;away;Belgium;2 europe;07-09;home;Malta;0 europe;07-09;away;Armenia;1 ...
Now you want to see the same information, but sorted by date and team.
First of all, download this sample file from the Packt Publishing website (www.packtpub.com/support). The name of the file is
matches.txt
.Now create a transformation, give it a name and description, and save it in a folder of your choice.
By using a Text file input step, read the file...