Compare two text file

Learning & Development Programs Automation Starter
6

Hey @nikhil.patil,

Use dt2Output=dt2.AsEnumerable().Where(Function(row) dt1.AsEnumerable().Any(Function(x) x(“NAME”).ToString=row(“NAME”).ToString)).CopyToDatatable to get the matching records from that two datatable and store the output in a third datatable object dt2Output.

Use dt2=dt2.AsEnumerable().Where(Function(row) NOT dt2Output.AsEnumerable().Any(Function(x) x(“NAME”).ToString=row(“NAME”).ToString)).CopyToDatatable

Thanks,
Sanjit