Tag Archives: VLOOKUP

Wean Off VLOOKUP with the Index-Match Combo

Whether you need to perform a quick & dirty join of two tables in Excel to fetch an attribute, or to build more robust (!) data blending for your data preparation, you might still be limiting yourself to just the … Continue reading

Posted in Excel | Tagged , , , | 1 Comment

How to Translate SQL Joins to Alteryx

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 … Continue reading

Posted in Alteryx, SQL | Tagged , , | 2 Comments