Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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!
Révélation
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.
