Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

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

Matt_Hancock
7 - Meteor

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

 

 

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

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

Matt_Hancock
7 - Meteor

That worked!  Thanks so much!!

Labels