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,
Hi @Speranta
If you coming to Alteryx from Excel there is a handy guide here - https://www.alteryx.com/resources/product-guides/alteryx-excel
You'd be able to do this in a complex way, but, to keep it simple it can be acheived using multiple Join tools, joining Input 2 against each RO column one at a time:
Note: Alteryx will not let you have multiple columns named the same, so i've called them Name, Nam2, Name3 etc
Workflow attached for you to have a look at!
@Speranta this had me thinking more than I expected for a solution without just joining (Although saying that, joining is good too)
Thank you all, very useful.