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

CandiceDB
Alteryx
Alteryx

My solution:

 

Spoiler
CandiceDB_0-1637940311542.png

 

BSilverblatt
8 - Asteroid

Thanks for the challenge! Here is my solution:

alexnajm
19 - Altair
19 - Altair

Good one!

Spoiler
challenge_71_start_file_Alex Abi-Najm.PNG
leozhang2work
10 - Fireball
Spoiler
71.png
VictorCruz
Alteryx
Alteryx

Good to learn the concepts... 😄

Victor Cruz
Sales Engineer, LATAM
Alteryx
allwynthomas24
11 - Bolide

Great Challenge to get hardcore hands-on experience on the UNION Tool plus SQL Join Concepts revised... All doubts got solved from this challenge... Thanks a lot... @MattD 

 

Spoiler
allwynthomas24_0-1640936811252.png
davidhardister
8 - Asteroid

davidhardister_0-1641392008283.png

 

Watermark
12 - Quasar
12 - Quasar

I don't typically set my flows up vertically but for this one with a focus on  "Left" and "Right" joins, it made a certain amount of sense.

 

Spoiler
MT Solution 71.png

Watermark
12 - Quasar
12 - Quasar
Spoiler
MT Solution 72.png

joelmiller66
9 - Comet
Spoiler
71 screenshot.png