Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #71: Recreate SQL Joins in Alteryx

Wouter
8 - Asteroid

My solution:

Spoiler
challenge 71.jpg
MarMu
8 - Asteroid

 

Easy one in the bank.

One observation though. The A and B anchors switched in the Output for "Full Join" and "Outer Join" compared to the rest?

 

Spoiler
challenge_71_start_file_MarMu.png
justynam
8 - Asteroid

My solution

jssandom
8 - Asteroid

An easy one :)

Justin_0
8 - Asteroid

Almost missed the outer join.  Actually struggled to figure out how to do left/right joins when I first came to Alteryx from SQL.  Pretty simple now, though.

JoshuaGostick
12 - Quasar

My solution :)

Spoiler
challenge_71.PNG
OldDogNewTricks
10 - Fireball

My solution is attached.

jbranaum
8 - Asteroid

My Solution

 

Nice and straightforward for me this time because I live in SQL land.....

 

 

Inactive User
Not applicable

Here is my solution.

KMiller
8 - Asteroid

Solution attached.