Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

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

Highlighted
8 - Asteroid

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

Highlighted
Alteryx Alumni (Retired)

@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

Highlighted
16 - Nebula
16 - Nebula

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?

Highlighted
14 - Magnetar
14 - Magnetar

Solution!

 

Spoiler
WeeklyChallenge29.JPG
Highlighted
Alteryx Certified Partner

Fun with data cleansing!

Highlighted
14 - Magnetar
14 - Magnetar

Love baseball. Fun challenge :)

 

Spoiler
Spoilerimage.png
Highlighted
Alteryx Certified Partner

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
Weekly Challenge 29.png
Highlighted
Alteryx Certified Partner

Solution attached

Highlighted
Alteryx Certified Partner

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

Spoiler
Spoiler
challenge29.jpg
Highlighted
Alteryx Certified Partner