Old habits die hard…
The main obstacle I found when ramping up on Alteryx was to understand how to perform a very basic task: Joining two tables!
The mainstream SQL way to Joins was ingrained in me, reinforced by Tableau Blending and Alteryx has adopted a quite different approach with the objective of being more user friendly by not requiring knowledge of SQL. Yet the first step is tricky, as the Alteryx way can require a sequence that adds the Union tool to the Join tool…
Here is the standard Alteryx explanation:
Yet, I wish I had this excellent resource when I started:
Kudos to Laszlo Zsom for detailing the respective approaches, and concluding with this summary to keep handy:
Now if you still can’t get over having to drop that old SQL habit while using Alteryx, there is an option for you: the Advanced Join tool!
This tool is not part of the “factory install” of Alteryx, and is not officially maintained, but it is a free macro, very easy to install and use:
It offers a very simple configuration:
And I tested it extensively, works great! Beats a VLOOKUP() any day if you ask me…