Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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

Challenge #29: Alteryx '16 Grand Prix (Race1, L1)

jasperlch
クエーサー

Solution attached.

dsmdavid
ボリード

On hindsight, should have moved the union to the front, but I originally had a join there to test for players that were both pitchers and batters (didn't know they were all different)...

スポイラ
29.png
msicak
アステロイド

manually arranging the fields and overlooking pitcher rank took me to 13 mins. would have been <10 otherwise, oh well :)

 

スポイラ
challenge29.png
blairmbailey
アステロイド

Solution attached - thanks!

dominiklz
アステロイド
スポイラ
Capture.PNG

nice excercise

MaxGiegerich
アステロイド
スポイラ
Weekly Challenge 29.png

I got a bit more artistic with the layout of this one...

MaxGiegerich
アステロイド

Apologies for the duplicate. Dodgy internet connection...

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

CHarrison
アステロイド

My solution :) 

Syfer889
メテオール

Okay, this is right down my alley! Sports Analytics. Loving it! However, where in the world is "team rank" coming from in the select tool at the end?????