In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. 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

Thomas_Wells_2dot0
8 - Asteroid

Solution attached. I didn't think to do this with only one Join, and multiple Union tools like some of the other posts... Oh well, using wireless connections cleaned up the workflow a bit :) 

 

 

Spoiler
2022-10-19_21-02-34.png
Supergiant
8 - Asteroid
Spoiler
Supergiant_0-1666621643616.png

 

leonhekkert
8 - Asteroid

My solution.

 

Spoiler
Challenge_71.png
Kinga
8 - Asteroid

Hi,

 

Please find my solution attached. 

 

Why is it described as Intermediate and Advanced? I think it should be Basic and Core. Good think to understand two Core Tools.

TungThanhHo
8 - Asteroid

my solution

AndrewHoData
8 - Asteroid

Here's my solution. Might have to come back to this one and try to solve it as an app or macro.

Spoiler
AndrewHoData_0-1668568985998.png

 

Ladarthure
14 - Magnetar
14 - Magnetar

My solution

JoachimCaronTIL
8 - Asteroid

Here is my solution

alfredcsy
8 - Asteroid

alfredcsy_0-1671461731207.png

 

StanleyKinnok_Chan
8 - Asteroid

here is my solution