How to match the value in between two excel

Help Studio
, ,
1

Hello guys,

I have a question.

I am attaching two excel files .

Demo-1.xlsx (8.4 KB)
Demo-2.xlsx (8.3 KB)

Both file have “Kohli” under “Name” column .

How can I match these two value using Uipath??

Thanks & Regards
Nirmalya

2

Hi @nirmalya.sarkar,

what do you mean by match here?
Do you want to check that the name Kohli belongs in the Demo2 excel or not? or someother thing.

Thanks

3

@Shikhar_Tandon ,

I want to check whether name kohli belongs in Demo1 or not.

Regards
Nirmalya

4

Try this:

yourDT.AsEnumerable().Any(Function(x) x("Column1").ToString = DesiredValue)
It will return True if any of the rows match the predicate.

Thanks

5

Hi @nirmalya.sarkar

if you need dynamic for a changing value in dt1

Refer to the xaml below!

Main.xaml (7.8 KB)
project.json (1.5 KB)

Regards

6

@nirmalya.sarkar
find starter help here:
Find_Common_NonCommon_By1Col.xaml (12.3 KB)

7

@pravin_calvin ,

Can you store the value in a variable as “Kohli” . It is my actual requirement.

Thanks & Regards
Nirmalya

8

@Shikhar_Tandon