Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI took a little liberty with this one, just to experiment a bit more .. I assigned points (much like they do in the World Cup - 3 pts per victory, 1 pt for a draw, 0 for a loss). The expected country still winds up on top of the table....
1. Input tool: Read it as delimited text file - other - insert \t
2. Formula tool to create a row with the winner in each match
3. Summarize tool: Group by winner and Count Winner