Compare Two Datatable and get only Unique(New) Data from DT2

Learning Initatives Automation Starter
1

Hi

Compare Two Datatable (DT1 and DT2) and get only Unique(New) Data from DT2
.
Thanks
Vishal

2

Hi,

How about the following expression?

dt2 = dt2.AsEnumerable.Except(dt1.AsEnumerable,DataRowComparer.Default).CopyToDataTable

Regards,

3

@Yoichi Thank you for help.

I have another question is
I want to Check on Specific Column. So How can I do

Thank You
Vishal

4

Hi @Vishal_Prajapati

Can you explain it with a sample input and output