Solutions to "Just KNIME It!" Challenge 27 - Season 2

Hi Everyone :slight_smile:

For this challenge, I filtered between the dates 01/01/2021 and 31/12/2022 because I don’t know when the football season begins and ends! Additionally, I filtered in rows only related to FIFA tournaments.
I then joined the confederations to the home and away teams and used the -Pivoting- node to calculate the matrix.

Thanks @sryu for the reminder to duplicate the rows where the home and away teams are different in order to make sure all matches are counted in the matrix!

I also wasn’t sure what to do with the shootouts table as the rows seemed to be present in the results table, but perhaps that’s due to a lack of football knowledge! haha

Here is link to my workflow on the hub:

Best wishes
Heather

5 Likes