Icon

C27_​Exploring World Cup Datasets

3 part workflow
1. Check if Shootouts contain teams not in Results. Regardless, concantenate rows
2. Join concantenated set with teams to get conference info for Home & Away teams
3. Create a Pivot Table for Conference Home & Conference Away. Value = Count of teams.
Clean up by removing not fifa and zero-ing missing values

Load Datasets1. Results will contain the main bulkof teams 2. Check if there are shootoutswhich do not appear in Results. Ifso, add to Results Get Conference data for each away & home team We use 2 Joins. 1 for each team type Check if there are teams in shootouts that are NOT in ResultsConcantenate with ResultsIn this case, it returns an empty table Rename Columns. Pivot on Conference Home & Conference Away. Drop conferences that aren't in FIFA Replace missing values with 0 resultsteamsNode 5Node 6Node 10Node 11Node 13Node 14Node 15Node 16Node 17ShootoutsNode 19Node 20Node 21Node 22Node 23Node 24 CSV Reader Excel Reader Date&Time-basedRow Filter String to Date&Time Joiner Column Filter Joiner Column Rename Pivoting Column Filter Rule-basedRow Filter CSV Reader Joiner Date&Time-basedRow Filter String to Date&Time Column Filter Concatenate Missing Value Load Datasets1. Results will contain the main bulkof teams 2. Check if there are shootoutswhich do not appear in Results. Ifso, add to Results Get Conference data for each away & home team We use 2 Joins. 1 for each team type Check if there are teams in shootouts that are NOT in ResultsConcantenate with ResultsIn this case, it returns an empty table Rename Columns. Pivot on Conference Home & Conference Away. Drop conferences that aren't in FIFA Replace missing values with 0 resultsteamsNode 5Node 6Node 10Node 11Node 13Node 14Node 15Node 16Node 17ShootoutsNode 19Node 20Node 21Node 22Node 23Node 24CSV Reader Excel Reader Date&Time-basedRow Filter String to Date&Time Joiner Column Filter Joiner Column Rename Pivoting Column Filter Rule-basedRow Filter CSV Reader Joiner Date&Time-basedRow Filter String to Date&Time Column Filter Concatenate Missing Value

Nodes

Extensions

Links