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

**URL:** <https://forum.knime.com/t/solutions-to-just-knime-it-challenge-27-season-2/72994>\
**Category:** Just KNIME It!\
**Tags:** justknimeit\
**Created:** [September 27, 2023, 2:47pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-27-season-2/72994 "2023-09-27T14:47:58Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![HeatherPikairos](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/h/a88e4f/32.png) [@HeatherPikairos](https://forum.knime.com/u/HeatherPikairos)\
**Post date:** [October 2, 2023, 11:50am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-27-season-2/72994/10 "2023-10-02T11:50:39Z")

</div>

Hi Everyone 🙂

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!

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/4/3475cd4cab410c5e01527cb1bcedf06b27b649f4.png)

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:

> **[20230929 Pikairos JustKNIMEIt Season 2 Challenge 27 Exploring World Cup...](https://hub.knime.com/heatherpikairos/spaces/Public/latest/Just%20KNIME%20It/Season%202/20230929%20Pikairos%20JustKNIMEIt%20Season%202%20Challenge%2027%20Exploring%20World%20Cup%20Datasets~UcADCvh2-p7KBzMK)**
>
> We explore World Cup datasets in this challenge, with the goal of seeing how many games under FIFA were played between different confederations in the last yea…

Best wishes  
Heather

---

_[View the full topic](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-27-season-2/72994)._
