Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Another fun parse-and-prep challenge!
Spoiler
I did a little experimenting with Performance Profiling turned on. In my first stab at this, I used Generate Rows to create a row for each overall pick, parsed the draft status from the player, and joined on year/round/position in round. The Join was fairly expensive, so I tried to think of ways to reduce that, such as keeping only one record per year/round and joining on that.
With this tiny dataset, changing the join to year/round (cutting the records in the incoming draft dataset by ~95%) didn't make a significant difference, but could be something to consider with a larger dataset.
I did a little experimenting with Performance Profiling turned on. In my first stab at this, I used Generate Rows to create a row for each overall pick, parsed the draft status from the player, and joined on year/round/position in round. The Join was fairly expensive, so I tried to think of ways to reduce that, such as keeping only one record per year/round and joining on that.
With this tiny dataset, changing the join to year/round (cutting the records in the incoming draft dataset by ~95%) didn't make a significant difference, but could be something to consider with a larger dataset.
Switch function is useful to simplify the IF statement on which round a player is drafted in.
