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
11 - Bolide

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.....

 

 

Suzu
9 - Comet

Here is my solution.

KMiller
8 - Asteroid

Solution attached.