Compare two data tables in different excel files

Help
, ,
8

Hey @Vamshi

You can use Following linq to get what you want :slight_smile:

Scenario is fetch the tags data from excel1 column and find in excel2 in Controller column only.

Datatable Final_result = (From x In dt1.AsEnumerable() where (From a In dt1.AsEnumerable() Join b In dt2.AsEnumerable() On a(“Controller”).ToString() Equals b(“Critical tags”).ToString() select a).Contains(x) select x).CopyToDataTable()

726.xlsx (8.9 KB)
Book1.xlsx (20.6 KB)

comparedt.xaml (11.2 KB)

Regards…!!
Aksh