Hi,
A little help for an alteryx newbie please! What would be the equivalent of a vlookup in alteryx?
Thanks!
The equivalent of a VLOOKUP would be a join in alteryx. You would need to assign the identifer columns from each table in the configuration pane. In this case my example would be the ID column in both tables.
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.
Regards,
Jonathan
Hi @JamesKing ,
Only complementing @Jonathan-Sherman answer, you have two ways of joining data, if you want to get the result as a vlookup table, you should use find replace tool and if you want to join 1-n, use the join tool.
Attached is an example showing how to get that done.
Best,
Fernando Vizcaino
Can anyone explain in very simple terms the concept of Vlookup in alteryx. Kindly help me know that. It's an urgency
A join is not the same as a vlookup. The output of a join can/will exclude records. Vlookup preserves all records from initial data source and appends columns.
