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
18 - Pollux
18 - Pollux

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