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)...

Spoiler

[msicak]

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

Spoiler

[blairmbailey]

Solution attached - thanks!

[dominiklz]

Spoiler

nice excercise

[MaxGiegerich]

Spoiler

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

[MaxGiegerich]

Apologies for the duplicate. Dodgy internet connection...

[JosephSerpis]

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?????