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.
Welcome to UiPath forum
Have a view on this and use .Contains instead of .Equals in the mentioned expression
welcome to forum
after checking the org name is containing first name or last name, what you need to do next ?
Thanks & Regards,
@Ulhas_Guttikar Can you share sample input and expected output
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.