I am working on a workflow that would take a list of vendor names and key words and match them to another list of vendor names and item descriptions. A field would be added to the vendor name/item description list that would contain the key word or words that matched that particular item description.
I was able to create a batch macro that accomplished this but matched all key words to all item descriptions.
I want to make it a little more specific and match both a key word and a vendor name. For example, there may be multiple item descriptions (and vendor names) that contain keyword1 but I only want it to match if the vendor name matches also.
I was trying to create a similar macro but I needed multiple inputs - one for the vendor name and one for the key word
I have attached a sample workflow with sample text inputs for both the vendor/keyword list and the vendor and item descriptions. The desired output is also in the vendor/Item description text input file.
