community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

How to match fields from two files and output the result to a new column in the first file

Meteoroid

Hi,

 

I have a process that is currently uses two excel files where a formula within my main file, compares its list of vendor numbers to a separate look up table and if that vendor number is found it returns a Y to a new column in a my main file.  I have most of the process moved into Alteryx, but I'm not sure how to structure

this process in Alteryx.

 

Here is a simplified example of what I'm trying to do where vendors 1 and 3 matched the look up table.

Main File.JPG

 

Here's an example of the look up table.

Look Up Table.JPG

 

I appreciate any help!

 

Thanks,

 

Matt

 

 

Highlighted
Alteryx Certified Partner

Hi @anon32  this set up below will produce the output you describe. I've attached the workflow as well.Join_110919.PNG

Meteoroid

That worked!  Thanks so much!!

Labels