Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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

jmckenna97
8 - Asteroid
 
mikeprice17
8 - Asteroid

Unlike most diehards on here I still prefer SQL. 

aanandkumar
8 - Asteroid

My solution! An easy, fun challenge!

LindaLo
8 - Asteroid

here you go

dpencheva
8 - Asteroid

Very good and interesting challenge! Especially for SQL users. Thank you!

Chantelb
9 - Comet
Spoiler
Chantelbbr_0-1584077235488.png

 

Reesetrain2
9 - Comet
9 - Comet

All,

 

Fun times!

Spoiler
-I had never completed an outer join then Union where you have the resultant set with items that didn't join in either location.
Capture.PNG

-Cheers!

 

Matt

 

AndrewS
11 - Bolide

#71

atcodedog05
22 - Nova
22 - Nova

On a spree to binge complete weekly challenges
Adrenaline rush

 

Spoiler
This is my solution

atcodedog05_0-1585451358560.png

 

aheikes
8 - Asteroid
Spoiler
Challenge71.JPG