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.

[IraWatt]

Hey @gaitonde25,

Can you attach the files containing the data sets?

Thanks,

Ira

[gaitonde25]

Hi @IraWatt , it's there. Please check once.

[IraWatt · Accepted solution]

@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