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

[luciebrett]

I did originally have the uppercase part later on using data cleansing but integrated into the formula tool.

[kcgreen]

Done

Spoiler

[aclaxton]

Thought I had the solution in under 10, but I had lost A.J. Polluk in my efforts to be quick :P

Still got it in under 20.

Spoiler

[maxjohnson02]

This was a fun one

[data_rachel]

Spoiler

Like @Natasha and others, I spent ages trying to work out how I was supposed to find (or create?) my missing field. Other than that, pretty standard answer. Except I used left joins, and I note that the official solution (and most other people) only used the joined fields. I didn't want to lose any of the players in my Picks. It doesn't seem to have made any difference in the final number of records though.

[KOBoyle]

Solution attached. I did similar to others. However, by my reading of the problem the solution should only have 252 records, matching the number of Fantasy Picks in the source. I did a little investigation to see that Matt Duffy is in the Hitter Stats source twice on two different teams, but I didn't spend time determining how best to merge to a single record. The fact that Duffy is counted as two players in the subsequent challenges creates a slight skew on some of the problems.

[daniel_ferreira]

Follow my solution file attached...

[JDelgado]

Fun stuff!