Check if column values are present in another excel file

Help Activities
,
1

In my process there are 2 excels.

One contains employee details like first name, last name. There may be more than 100 emp details.

Second excel contains org. Org names like google.com, facebook.com. the cound of org name is around 200

Sometimes org name can contain emp first or last in org name.

Is there any way to check if org name contains emp name except looping through each row.

I need to check each org name, if it contains any employee name from first excel.

Thank you in advance.

2

Hi @Ulhas_Guttikar,

Check this,

3

Hi

Welcome to UiPath forum

Have a view on this and use .Contains instead of .Equals in the mentioned expression

Cheers @Ulhas_Guttikar

4

Hi @Ulhas_Guttikar
welcome to forum

after checking the org name is containing first name or last name, what you need to do next ?
Thanks & Regards,
Nived N

5

@Ulhas_Guttikar Can you share sample input and expected output

6

if any org name contain emp name, there is third excel file which will be updated.

If I get result in Boolean that can also work.