Recreate a vlookup formula from excel in alteryx designer

Question

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.

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

gabrielvilella · Answer

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

Join.yxmd

Luke_C · Answer

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.

avilla34 · Answer

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!!

SampleData.xlsx