Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

ARussell34
8 - Asteroid

Join, join, join. Glad to review the join and union tools!

Erin
9 - Comet

I am a visual person and really appreciated the SQL Joins chart in the description, so I added it to my workflow:

Spoiler
BronzeFox_0-1629923600260.png

Ran some checks to the provided output and we're all square! Don't miss the Inner Join in the middle, kind of hidden in the picture.

dheissner
Alteryx
Alteryx

Finished

Spoiler
dheissner_0-1631660340413.png

 

TimN
13 - Pulsar
Spoiler
A bit messy But works
MichelleL
Alteryx
Alteryx

Jamming with joins (and unions) . . .

BenFr
Alteryx
Alteryx

Good to understand terminology used within SQL

reyreygg
8 - Asteroid

😀

Anmol97
8 - Asteroid

Here's my solution

KodyKlein
6 - Meteoroid

Solved! 😄 

Harrylosborne
8 - Asteroid
Spoiler
Harrylosborne_0-1637144003948.png