Icon

FIFA World Cup

<p>The source code/inputs for this workflow can be obtained from GitHub at the following location: <br>https://github.com/pseudo-r/Public-ESPN-API<br><br>I used Claude Fable to source it's data from GitHub and build the python scripts to run and process the main input file. <br><br>I then had Claude outline the necessary workflow steps in KNIME to effectively build this workflow. I build each step as outlined in Claude to essentially proof the workflow and it seems to work well. <br><br>The final step is the dashboard component that allows you to select each team or teams to visually observe which team has the better status and guide you to build a bracket--which seems impossible for a FIFA World Cup event. </p>

ESPN - Github Public APIs (via Python scraping)

Men's FIFA World Cup

WinnerScore
Rule Engine
Loser
Rule Engine
LoserScore
Rule Engine
WentToPenalties
Math Formula
AwayWins=1AwayWins!=1
Row Splitter
HomeWins=1HomeWins!=1
Row Splitter
WinnersFIFA Worldcup Standings
Joiner
Winners
Concatenate
Losers
Concatenate
Winners
Column Renamer
Losers
Column Renamer
LosersFIFA Worldcup Standings
Joiner
Concatenate
UpsetScore
Math Formula
Missing Value
FurthestRound
Rule Engine
IsUpset
Math Formula
RoundOrder
Rule Engine
GroupBy
05 Upset Detection
Sorter
Column Renamer
2026 Groups
Row Filter
HistoricalGroup Stage Avg
GroupBy
Column Filter
!=2026All Years whenScores Available
Row Filter
Column Renamer
GroupBy
Groupby: Team
GroupBy
Best RoundOrder
Column Renamer
SetPieceGoalsPG
Math Formula
Column Renamer
Column Resorter
SetPieceDanger
Column Expressions (legacy)
Joiner
TotalGoalsPerGame
Math Formula
Column Renamer
Groupby: TeamName
GroupBy
All Years whenScores Available
Row Filter
ScoreBSetPiece
Sorter
ShootoutAttempts
Math Formula
ShootOut Goals>0 ORShootOutMisses >0
Row Filter
ShootoutRecord
Column Expressions (legacy)
Historial WinRate
Column Expressions (legacy)
HistoricalTournamentDepthHistorical Group Avg
Column Renamer
Best Round
Rule Engine
Join 2
Joiner
Join 1
Joiner
Max_pts
Column Renamer
Column Renamer
MaxAvgGrpts
Column Aggregator
Groupby: TeamName
GroupBy
CareerShootoutRecord
Math Formula
MaxAvgFurthestRoundOrder
Column Aggregator
CareerShootoutAttempts
Math Formula
All Years whenScores Available
Row Filter
ScoreCShootout
Sorter
Column Renamer
Groupby: TeamName
GroupBy
ReachedSF
Rule Engine
01 tournament progression!=2026All Years whenScores Available
Row Filter
Max_round
Column Renamer
Calc: AvgGroupPtsAvgFurthestRoundOrder
GroupBy
StrengthScore Updatefor each data refreshAvgGrpPts, FurthestRnd,HistoricalWinRate
Column Expressions (legacy)
Column Renamer
Cross Joiner
06 Bracket Seeding 2026
Sorter
ReachedFinal
Rule Engine
StrengthScore
Column Expressions (legacy)
FIFA Worldcup Matches
Excel Reader
Groupby: Year-Round-Team-Abbv
GroupBy
All Years whenScores Available
Row Filter
Column Renamer
All Years except 2026All Years whenScores Available
Row Filter
Excel Writer
Groupby: Team
GroupBy
AvgGAConceded
Math Formula
FIFA Worldcup Standings
Excel Reader
Cleansheets
Math Formula
Joiner
CleanSheetRate
Math Formula
Column Renamer
TeamRoundStatSaves
Column Renamer
ScoreDClutch
Sorter
Year-RoundNameTeamName-savesshotsFaced
Column Filter
KnockoutClutchScore
Expression
Joiner
SavePct
Column Expressions (legacy)
DisciplineStrength
Joiner
FoulRate
Math Formula
RedRate
Math Formula
FIFA WorldcupTeam Stats
Excel Reader
YellowRate
Math Formula
Column Renamer
Groupby: TeamName
GroupBy
Home Team Matches
Column Filter
DisciplineScore
Math Formula
Column Renamer
Column Renamer
Away Team Matches
Column Filter
DisciplineStrength
Math Formula
SavePct=0
Missing Value
All Years whenScores Available
Row Filter
ShootoutRecord
Joiner
Union: Home Team &Away Team Matches
Concatenate
ScoreADiscipline
Sorter
SetPieceDanger
Joiner
Result
Rule Engine
Total StatsSavesTotal ShotsFacedTotal SavePct
GroupBy
Concatenate
Loss
Math Formula
FurthestRound
Rule Engine
SetPieceGoals
Math Formula
KnockoutClutch
Joiner
!=2026All Years whenScores Available
Row Filter
GroupBy
03 Defensive Record
Sorter
Missing Value
SoTPerGame
Math Formula
Cross Joiner
ShotsPerGame
Math Formula
Column Renamer
GoalsPerGame
Math Formula
StrengthScoreV2AvgGrpPts, MaxPts,FurthestRndOrder,MaxRound,WinRate,KnockoutClutchScore,MaxClutch,AvgSetPieceDanger,CareerShootoutRecord
Expression
YellowsPerGame
Math Formula
WinRateBand
Rule Engine
RoundOrderTEAM_CENTRIC
Rule Engine
Column Renamer
Groupby: Year-Team-Abbv-TeamID
GroupBy
TotalPoints
Math Formula
GD
Math Formula
WinRate
Math Formula
Column Filter
GoalsPerMatch
Math Formula
Column Filter
04a Win Pred Band
Column Renamer
FIFA Worldcup Match Stats
Excel Reader
FurthestRound
Rule Engine
Groupby: WinRateBand
GroupBy
ScoreEStrengthV2
Sorter
Create custom binsfor SoTPerGame
Binner
Row Filter
01 Tournament Progression
Sorter
GroupBy
Column Renamer
GroupBy
Groupby: SoTBucket
GroupBy
GroupBy
Bins for ShotsPerGame
Binner
04b SoT vs WinRate
Column Renamer
2026 Group AvgPts
Row Filter
04c Shots vs WinRate
Column Renamer
Groupby:ShotsPerGame(Binned)
GroupBy
Groupby: Year-Round-Team-Abbv
GroupBy
All Years except 2026All Years whenScores Available
Row Filter
Consolidated FIFADashboard
Dashboard
GoalsPerMatch
Math Formula
Column Renamer
ShotsPerMatch
Math Formula
Column Expressions (legacy)
Bins for YellowsPerGame
Binner
02 Scoring Power
Sorter
04d Cards vs WinRate
Column Renamer
FurthestRound
Rule Engine
Groupby: YellowsPerGame(Binned)
GroupBy
Column Filter
!=2026All Years whenScores Available
Row Filter
Winner
Rule Engine
All Years whenScores Available
Row Filter

Nodes

Extensions

  • No modules found

Links