We want to achieve output based on the first dataset

gaitonde25

First data set is in attached file

We want to filter out data from 2nd dataset where territory contains this values(SciOps,MSL,Med Adv). It will dynamically change . So we need to filter out data based on this value from 2nd data set

Here is the 2nd data set:

we have to find out the rows that contains SciOps,MSL and Med Adv from the 2nd file.

Let me know in case of any queries.

Thank You in Advance.

Screenshot 2022-07-28 142534.png

Screenshot 2022-07-28 143030.png

IraWatt

@gaitonde25 I checked they are screenshots, not data files. I typed one them up and I think what you want is the find and replace tool. It will be able to find if your territory text appears in which record:

Any questions or issues please ask.

Ira Watt
Technical Consultant
Watt@Bulien.com 

Workflow.yxmd