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

RobertOdera
13 - Pulsar
 
TonyA
Alteryx Alumni (Retired)

Here's my solution.

hbraunius
8 - Asteroid

My solution attached.

hanykowska
11 - Bolide
 
Thableaus
17 - Castor
17 - Castor

Challenge #71, done.

 

Spoiler
Challenge_71.PNG

Cheers,

cgoodman3
14 - Magnetar
14 - Magnetar

My solution

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
T_Willins
14 - Magnetar
14 - Magnetar

Join and Union tools make this easy.  For a real challenge, recreate this in Excel...or don't since you never will again!

 

Spoiler
Workflow 71.GIF

 

papalow
8 - Asteroid

This was a good refresher on sql joins

nakamott
8 - Asteroid

solution

anaibeth
8 - Asteroid

Just realized I didnt really know how the join tool worked here on alteryx. This was great, thanks!!

 

Here's my solution.

Challenge 71.PNG