Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Recreate a vlookup formula from excel in alteryx designer

avilla34
7 - Meteor

I am comparing two variables from two different data sets to make sure they match. If they are identical I would like to obtain a unique number found within one of the data sets and create a new column.

avilla34_0-1648238014898.png

Can you demonstrate how this could be recreated using the join tool?

5 REPLIES 5
gabrielvilella
14 - Magnetar

This would be easy to demonstrate with some sample data if you could share that. I encourage you open the example workflow for the Join, just right click on the tool.

gabrielvilella_0-1648239022191.png

 

DavidSkaife
13 - Pulsar

Hi @avilla34 

 

In addition to @gabrielvilella suggestion there is also some resources provided by Alteryx for excel users; https://www.alteryx.com/resources/product-guides/alteryx-excel

 

Vlookups are down near the bottom.

avilla34
7 - Meteor

Hello, 

I am attaching an excel sheet that contains the sample data you requested. We would like to match the values from column S in the SCR tab with the values from column A in the ASL tab to produce the values that are in column U in the ASL tab to column AA in the SCR tab. We would like for the AA column to be autofilled automatically like excel.

 

Currently, we use excel using a vlookup formula "=VLOOKUP(S2,'ASL'!A:AV,21,FALSE)"

 

How can we do this using the join tool, or any tool that could apply within alteryx?

 

Any help you can provide would be greatly appreciated!! 

Luke_C
17 - Castor

Hi @avilla34 

 

Bring both tabs in as inputs and use the join tool to join on the supplier ID field. Like others have mentioned above, there are plenty of resources to help. You'll get much more out of it doing it yourself versus someone giving you the answer. Give it a go and attach your workflow here if you run into any issues. 

gabrielvilella
14 - Magnetar

When working is Alteryx, use the table headers to reference the fields you want rather than AA, U. I attached the workflow here.

Labels