How to compare the full rows of two different datatable

Hi All,

I have the compare the full rows of datatable dt1 and datatable dt2. All the rows of dt1 which are not present in dt2 , I have to copy all those rows and paste it dt2 below the present rows in dt2

Use Merge

Could you please explain in detail?

Hi @Karan28,

Can you please refer below link

Hope this helps.



Check below post

Mark as solution if this helps


PFA for sample
Merge_Dt_WithUnique.xaml (7.9 KB)

IT Sounds that all columns are to Check
Have a Look Here as Well for identfying the rows for the merge

Hey are we merging on the basis of which column?

Not satisfying my condition here Kanad.