Icon

Just KNIME it-2_​Challenge-27_​v1


Just KNIME it-2_Challenge-27_v1

- 1 data in shootout is missing in result data
- There are 2 Guams in team file
- I'm not sure when FIFA starts, so I just used data from 20210401 to 20220331
- Most matches in FIFA seems to be done in the same confederations

All shootout data should beincluded in result, but one ismissingSaare county vs Aland islandswere somehow deleted inresult.csv Somehow there're 2 Guam inthe list teamshootoutresultdate_teams547date_teams44363add only winner4436320210401~20220331Time can be wrong1179only FIFA598add 1orderadd 0 Excel Reader CSV Reader CSV Reader String Manipulation String Manipulation Joiner Joiner strange String to Date&Time Date&Time-basedRow Filter Row Filter GroupBy Row Filter Joiner Column Rename Pivoting ConstantValue Column Column Resorter Table View RowID Missing Value All shootout data should beincluded in result, but one ismissingSaare county vs Aland islandswere somehow deleted inresult.csv Somehow there're 2 Guam inthe list teamshootoutresultdate_teams547date_teams44363add only winner4436320210401~20220331Time can be wrong1179only FIFA598add 1orderadd 0Excel Reader CSV Reader CSV Reader String Manipulation String Manipulation Joiner Joiner strange String to Date&Time Date&Time-basedRow Filter Row Filter GroupBy Row Filter Joiner Column Rename Pivoting ConstantValue Column Column Resorter Table View RowID Missing Value

Nodes

Extensions

Links