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

my solution

JethroChen
10 - Fireball
Spoiler
challenge_71_jc.PNG
bjkay30
8 - Asteroid

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.

 

Spoiler
bjkay30_0-1600195714409.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

Spoiler

AkimasaKajitani_1-1600348101095.png

 


 

LukaszKarpinski
8 - Asteroid

My solution attached.

JoePC
9 - Comet

Solution Attached

Qiu
20 - Arcturus
20 - Arcturus

Learned about SQL.

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

 

Spoiler
071 - SQL joins - Kilian.png
Sylvana
8 - Asteroid

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
8 - Asteroid
Spoiler
tammybrown_tds_0-1603213941124.png