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?
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.
<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!
@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 ;)
Sorry, but my dog ate my homework.
No pretty pictures here today....