I have two Excel files from which I’ve read data into two separate DataTables: one serves as the master DataTable, and the other represents the downloaded DataTable. Now, my objective is to compare the rows in the downloaded DataTable with those in the master DataTable. If there are identical rows in the master DataTable, I intend to remove those corresponding rows from the downloaded Excel file and retain only the unique records.
we can compare both datatables with column Spool .
if spool number is there in master excel then we have to ignore it only rows whose spool is not there in master excel should me there in the datatable.
Thanks for your reply.
But here you are checking whole table.
I want to put check on one column value and if it matches the remove it from the downloaded dt.
it is because the columns are not stable they can increase or decrease.