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

wwatson
Quasar

my solution

JethroChen
Boule de feu
Révélation
challenge_71_jc.PNG
bjkay30
Astéroïde

Here's my submission.  I always refer to the picture in the original post when trying to help others understand joins.  Glad to know it's so easy to do in Alteryx, too.

 

Révélation
bjkay30_0-1600195714409.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

Révélation

AkimasaKajitani_1-1600348101095.png

 


 

LukaszKarpinski
Astéroïde

My solution attached.

JoePC
Comète

Solution Attached

Qiu
21 - Polaris
21 - Polaris

Learned about SQL.

Révélation
en-71.PNG
KilianL
Alteryx Alumni (Retired)

Great to see how SQL joins look like in Alteryx by creating all possible combinations of the Join Tools output anchors.

 

Who likes math to check if we got all?: C(3,2) + C(3,3) = 7 combinations. We catched them all.

 

Révélation
071 - SQL joins - Kilian.png
Sylvana
Astéroïde

I was struggeling with the joins when I started with Alteryx at first. I then learned how it works quickly. Therefore the challenge was quick and easy now 🙂

 

tammybrown_tds
Comète
Révélation
tammybrown_tds_0-1603213941124.png