Comparing two data tables


#22

Hi @Ananthu,
thank you for help. I understand now everything clear -)
Have a nice weekend.
Agata


#23

Have a great weekend!


#24

Hi Ananthu,

I am stuck in a similar problem…

I have two data tables, one contains the names, another datatable contains another set of names, i just need to check if the name in dt1 is present in dt2.

can you please help me?EXCELanasys.xaml (35.2 KB)


#25

Hi shreyaank,
Ya sure! I will send you the workflow by tomorrow…

Thanks and regards,
Ananthu


#26

Hi @shreyaank,
I have verified your work flow. You have to initialize the variable i to 0. If you still have issues, kindly send me the excel sheet so that I could verify.

Thanks and regards,
Ananthu


#27

_testsheet1.xlsx (12.1 KB)
testsheet2.xlsx (306.3 KB)

Hi Ananthu,

i have uploaded testsheet 1 and testsheet 2,

i want to check if the name frm sheet1_is present in sheet2. if it is present, it should display yes or else No


#28

Hi Ananthu,

I have made the changes, still getting error. Please have a look.
EXCELanasys (1).xaml (37.0 KB)
image