Challenge #30: Alteryx '16 Grand Prix (Race 1, L2)

[Parul_Kapoor]

Here is the solution.

[Shifty]

Should've used the Sample tool to pull the top answer (I'll know for next time) and there are a bunch of other unorthodox ways (read: unnecessarily complex) to get to the solution but I got there.  

It was a nice challenge and a good introduction to the Data Investigation tools!

Spoiler

[NatSnook]

solution attached

[PhilBalderson]

Spoiler

Tough! 

[mbogusz]

Didn't know/think of using the Summarize tool's 'First' functionality.  I had used a Join tool with the Unique tool by Fantasy Team and 2015 Team Rank instead.  Using the Summarize tool's 'First' function is definitely the better way to go for the 4th part of the exercise.

Answer to the 4th part of the exercise, "Please build a table containing the count of players on each fantasy team by position, the sum of home runs for the hitters by fantasy team, and sum of wins for the pitchers by fantasy team, ordered by 2015 team rank."

[SandeepSK]

Spoiler

Solution as seen below. 

[Angela_Menegassi]

Used a Find Replace to put 2015 Team Rank back to the data because I didn't realize I could have done it directly using the Summarize tool. Oh well, solving challenges and learning!

[Garrett]

6:59:91

[RobertoEstrada]

Solution ready, this was simple