Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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