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

[martinding]

Spoiler

 

[ExploreMore]

Spoiler

 

[Martin_F]

done!

[mattnason1]

Couldn't find team rank, and couldn't find it in the solution either.  Wondering if the data set has changed?

Otherwise all matches.

[mgaronson]

Spoiler

Joining on Player field is tenuous. Have to convert Stat files Player field to uppercase to make this work.

Learned the Union tool can be useful for 'combining' fields and may unintentionally 'combine' data, too! Use with caution.

[MilindG]

Spoiler

[mark007]

Solved!

[lifranca]

It took me some time to understand why I was starting with 252 rows and ending with 253. There are two different players called MATT DUFFY.

I don’t know if I should have done that but I only considered the best ranked.

[isobeltaylor]

Caused a few complications when removing punctuation for #Rank and then joining. Better to use a formula tool to be specific

[karlhansen]

Spoiler

I could not figure out where the 2015 rank came from.