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

[markp201]

Curious - is there a performance gain by having the two joins followed byt a union?

[GeneR]

@markp201,

There is not a performance gain,  I was solving the problem as fast as I could at the time and was thinking that a Batter may also have pitching stats.  I want to keep the two sides isolated then bring in the data with the union.

Since there are not any batters that are pitchers it could be solved with just two joins in series like the winner did.

I had no involvement in creating the exercise initally, else I would have wanted to fix the header typo and only have 27 instead of 28 columns in the result.  (there is a column called Stike outs and one called Strike outs that could have been aligned)

Best Regards,

@GeneR

[SeanAdams]

Similar solution as those provide.    Sadly, well over 10 mins spent (mainly trying to figure out differences between my answers and the provided solution) - so DNF for me...

Note for @GeneR / @TaraM.   It seems that one field is missing from the data provided (both in the start file, and the provided solution also fails on this field) - "2015 Team Rank".   It may be that this was supposed to be 4 data sets originally?

[NicoleJohnson]

Solution!

Spoiler

[Garrett]

Fun with data cleansing!

[estherb47]

Love baseball. Fun challenge :)

Spoiler

Spoiler

[LordNeilLord]

I spent ages trying to figure out why the join wasn't working, then I realised it was because I didn't read the instructions properly...

Spoiler

[nick_ceneviva]

Solution attached

[Laurap1228]

Here is my solution. Haven't checked it with the answer provided but I imagine it's quite similar.

Spoiler

Spoiler