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.
Here's an example of the look up table.
I appreciate any help!
Thanks,
Matt
Solved! Go to Solution.
Hi @Matt_Hancock this set up below will produce the output you describe. I've attached the workflow as well.
That worked! Thanks so much!!