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

[nikolaskardasis]

Spoiler

[DawnDuong]

Thanks for posting the challenge.

Spoiler

Now I know how to use Dynamic Rename.

[TonyA]

Pretty straightforward. I was thrown for a minute when I couldn't find the 2015 rankings but it looks like that got dropped from the source data.

[nnilz]

Solution attached, very similar to the original solution although I tried to cut a corner with multiple join

[nakamott]

my solution. Could not figure out how the column 2015 Team Rank was generated in solution

[catherineduffy]

Solution attached

[rachelgatto]

Solved. 

[Shifty]

I kept the hitters and pitchers separate as I thought there would be overlap but apparently there isn't so just the 30 superfluous steps for Shifty!

Spoiler

[jdemeaux]

No way Mike Trout is not Pick#1!! Just saying! ^^