Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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
Asteroide

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
Asteroide
Spoiler
Supergiant_0-1666621643616.png

 

leonhekkert
Asteroide

My solution.

 

Spoiler
Challenge_71.png
Kinga
Asteroide

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
Asteroide

my solution

AndrewHoData
Asteroide

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
Asteroide

Here is my solution

alfredcsy
Asteroide

alfredcsy_0-1671461731207.png

 

StanleyKinnok_Chan
Asteroide

here is my solution