Vlookup on multiple columns

Question

Dear all, hope you can help with the following situation:

I have one table (Input table 1) with multiple columns and I need to add for each column other 2 columns( Name and Manager) from Input table 2. Normally in excel I use VLOOKUP for each column.

Is there any way that I can do this in Alteryx even if I need to use multiple connections?

Thanks,

Input table 2.xlsx

Output.xlsx

Input table 1.xlsx

Speranta · Answer

Thank you all, very useful.

Christina_H · Answer

You can do this with multiple joins, however Alteryx also gives you other options.  Here's a more dynamic option using Transpose, which should scale to more RO columns.

Multiple lookups.yxmd

JamesCharnley · Answer

@Speranta this had me thinking more than I expected for a solution without just joining (Although saying that, joining is good too)

ManagerROs.yxzp