How to compare the full rows of two different datatable

[Karan28 (Karan Arora)]

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

[KanadMehta]

Use Merge

DataTable.Merge Method (System.Data)

[Karan28 (Karan Arora)]

Could you please explain in detail?

[1996 (Neelima G)]

Hi @Karan28,

Can you please refer below link

Comparing two data tables

Hi Gaurav, I have attached the comparison logic workflow. Kindly let me know if you got struck somewhere. Thanks and regards, Ananthu Comparison logic.xaml (22.3 KB)

Hope this helps.

Thanks,
Neelima.

[Srini84 (Srinivas)]

@Karan28

Check below post

Comparing two data tables

Hi , Could you please share the solution here , Regards Smitha

Mark as solution if this helps

Thanks

[KanadMehta]

PFA for sample
Merge_Dt_WithUnique.xaml (7.9 KB)

[ppr (Peter Preuss)]

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

[HowTo] - Find Duplicate / NonDuplicate rows - checking all columns - without explicit listing the colnames/index

Introduction In the majority of scenarios duplicated / Non duplicated rows can be identified by a few columns grace to the key column concept. In order to retrieve it, the group by approach helps It can be done e.g. with some nice components from Connect or LINQ In some scenarios all duplicated / non duplicated rows should be detected by checking all columns. Setting up an approach without explicit listing all column names or column index would speed up the implementation. Implementat…

[Karan28 (Karan Arora)]

Hey are we merging on the basis of which column?

[Karan28 (Karan Arora)]

Not satisfying my condition here Kanad.