Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #212: Draft Masters

Highlighted
7 - Meteor

I know there must be a more efficient way of cleaning up the draft pick value table but I have been doing my best to resist looking at solutions until after I've uploaded so here we go. Aside from that, once the data is clean the solution is fairly straight forward

 

Spoiler
YomaraA_0-1590672096429.png

 

 EDIT: So today I learned what the Arrange Tool is and what it's for!! Woohoo!

Screenshot of new workflow has been added.

 

Spoiler
YomaraA_0-1590672344132.png

 

Highlighted
5 - Atom

My first submission. Nice use of Arrange tool.

 

Spoiler
Challenge 212.jpg
Highlighted
8 - Asteroid

Highlighted
5 - Atom

Don't know if it's late, but here is my version.

Highlighted
9 - Comet

Did it in a few ore tools but still got there! Fun challenge.

Highlighted
Alteryx Certified Partner

My solution

 

Spoiler
challenge_212.PNG
Highlighted
8 - Asteroid

fun little challenge.  my results match the results with the string conversion.

 

 

Highlighted
Alteryx Certified Partner

90% of time went into finding the motivation to understand why anybody would want to do this type of analysis. But now I finally know that I still don't have an answer but reverse engineering the solution to figure out what type of data process was required helped me to create this workflow - and I still have absolutely no idea why this needed to be done so if anyone can help me out here to understand this US basketball stuff, that would be great.

 

Spoiler
212.jpg
Highlighted
9 - Comet

Hi ,

 

Here is my answer.

 

Best Regards,

Samuel

Highlighted
8 - Asteroid
Spoiler
Challenge 212 2020-06-16.jpg