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.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #71: Recreate SQL Joins in Alteryx

KevinTang
8 - Asteroid

done, good refresh of the join function

mpennington
11 - Bolide

Solution attached.

 

Spoiler
MP71.png
AngelosPachis
15 - Aurora

Challenge #71 is done

 

Spoiler
challenge#71.png
deepaprash
8 - Asteroid

Done

cc000072
8 - Asteroid

Here is my solution.

Spoiler
WeeklyChallenge_Ryohei_71.JPG
JonathanW
8 - Asteroid

Solved

 

Spoiler
JonathanW_0-1593580452968.png

 

AnaisComyn
9 - Comet

Done !

treepruner
9 - Comet

I get that maybe you want to do something with the unmatched records on the outer join, but I really wish I could just specify the join type in the tool, too.

jarrod
12 - Quasar
12 - Quasar

This is one of the first things i did with Alteryx without ever learning the SQL joins. Now i use it every day.

Spoiler
jarrod_0-1594923199022.png

 

Verakso
10 - Fireball

A query walks into a bar, when some tables said

giphy

 

 

 

 

 

 

 

 

 

 

 

 

Spoiler
2020-07-30 12_46_27-Window.png

Nothing a little join and union tool can't handle 

Still Climbing
/Verakso