ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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
Asteroid

My solution:

Spoiler
challenge 71.jpg
MarMu
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
Asteroid

My solution

jssandom
Asteroid

An easy one :)

Justin_0
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
Quasar

My solution :)

Spoiler
challenge_71.PNG
OldDogNewTricks
Feuerball

My solution is attached.

jbranaum
Asteroid

My Solution

 

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

 

 

Inactive User
Nicht anwendbar

Here is my solution.

KMiller
Asteroid

Solution attached.