Challenge #71: Recreate SQL Joins in Alteryx

[MattD]

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?

Spoiler

Hint: this should be easier for those of you who have mastered the Union Tool.

[alex]

Who's gonna join the fun this week and submit their workflows?

[Natasha]

Thanks for a quick SQL joins recap, though I find Alteryx joins are so much more intuitive!

[NicoleJohnson]

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 :)

Spoiler

[SeanAdams]

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)

Spoiler

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!

Sean

[SeanAdams]

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?   :-)

[estherb47]

Oh my, lots of browses to show the different joins. Much simpler than SQL!!

Spoiler

Spoiler

[NicoleJohnson]

@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 ;)

[Simona]

Pretty nice exercise, I found it quite easy but it was a good refresh for the wording :)

Attached my solution :)

Spoiler

[MarqueeCrew]

Sorry, but my dog ate my homework.

No pretty pictures here today....

Cheers,

Mark