How to find duplicate value

Learning & Development Programs Automation Starter
1

Hello,

How to find duplicate values from different Data Table.
Ex. One Data Table column values:
Column 1
OperaTB
OperaMS
OperaMR
OperaAR

  Second Data Table column values:
   Column 1 
   OperaTB
   OperaMS
   OperaMS
   OperaAR

OutPut: Duplicate values are OperaMS

Thanks
Nikhil Patil

1 Like
2

Hey @nikhil.patil

Kindly try the below,

DT_Result = DT1.AsEnumerable.Where(Function(row) DT2.AsEnumerable.Where(Function(row2) row2("Column 1").ToString.Equals(row("Column 1").ToString)).Count > 0).CopyToDataTable

Hope this helps.

Thanks
#nK