How To Compare Two Excel Files Of The Same Format And Get Matched Data?
While dealing with data table operations, sometimes we might want to compare two data tables and get matched data (From a In SourceDT.AsEnumerable Join b In Destination_Table.AsEnumerable On a(“Column_Name”).ToString Equals b(“Column_Name”).tostring Select a).CopyToDataTable.Select().CopyToDataTable().DefaultView.toTable(False,”Name”) Replace “SourceDT” and “DestinationDT” with your required data tables and “Column_Name” with your required column name that you want to match with … Continue reading How To Compare Two Excel Files Of The Same Format And Get Matched Data?