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

[JethroChen]

Spoiler

[DemandEngineer]

This one had a nice twist.  I originally converted to title case... but that caused one entry to not match... this was because the letter after an apostrophe was lower case... Should title case be able to handle that?

Also, I didn't try to match up the field types... some of my strings could be Byte or Int16 etc... is that just for more efficiency or future processing that need a certain field type?

[fimler]

I wouldnt have wont any races putting this together but it was fun....

[JoePC]

Solution Attached

[Qiu]

Fun one!

Spoiler

[gregchristensen]

Spoiler

[Leanne1]

Another solution! Woot...Woot!

Love the Dynamic rename tool!

[LukasJennings]

Spoiler

[anshuverma0912]

Hi, Here is my solution. Just as others mentioned, 2015 Rank column is missing. However my number of records are also 252 instead of 253. This is because of Record "TRAVIS D'ARNAUD" which is missing in Fantasy League Picks. How is this included in results, I am not able to get that.

[Emil_Kos]

Hi,

A very interesting challenge.

Spoiler