This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
The solution to last week's challenge is HERE!
Today’s challenge is for all of our analysts and data scientists who used SQL in a past (or their current) lifetime! Using the schematic above, can you recreate all the SQL joins with the Alteryx Join Tool and the datasets we have provided?
My solution! And just for kicks, did it as an app! Pick your join type and it will give you the results... SOOO much more fun than writing boring old SQL queries :)
So - I sacrificed utility for prettiness <shameful grin> and there's a few components in there that aren't needed but gave me a nice symmetry to the whole thing, and gave me a place to hang a label.
Oh, and just to add insult to injury, in making this nice and symmetrical, it also becomes less readable than @alex and @Natasha 's solutions because all the inbound connectors overlap.
<grin> yes - pretty silly trade-off, I know (less readable, less efficient, but easier on the eye)
I've packaged my workflow along with a simple macro that allows you to check your results with very little effort
Have a good week all - 4 more to go!
PS - for extra credit @NicoleJohnson - perhaps worth trying this with detour components or Dynamic Replace (thanks to @Joe_Mako for challenging me to learn this one).
If you're going to over-achieve, why not push the boat out ALL the way? :-)
Oh my, lots of browses to show the different joins. Much simpler than SQL!!
@SeanAdams I actually tried Detours first, but kept detouring myself into errors... :) I will definitely give it a go again though! Can't guarantee it will be as pretty as yours, however... what a masterpiece! We'll just call you Vincent van Alteryx ;)
Pretty nice exercise, I found it quite easy but it was a good refresh for the wording :)
Attached my solution :)
Sorry, but my dog ate my homework.
No pretty pictures here today....