Vlookup In Alteryx?

[JamesKing]

Hi,

A little help for an alteryx newbie please! What would be the equivalent of a vlookup in alteryx?

Thanks!

[Jonathan-Sherman · Accepted solution]

Hi,

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

[fmvizcaino]

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

[JamesKing]

Thanks to both of you! fmvizcaino it doesn't look as though I could do nested Vlookup functions with the find and replace tool?

[fmvizcaino]

Yes @JamesKing .

That is a way to create a nested vlookup, but you can do that also with the join tool as long as you have an ideal secondary table for your nested vlookup.

Best,

Fernando V. 

[Kshitijs]

Can anyone explain in very simple terms the concept of Vlookup in alteryx. Kindly help me know that. It's an urgency