Find the duplicate values from column

[nikhil.patil]

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

[rohith.prabhu]

Hello @nikhil.patil ,

You can use the below expression to get the matched records present in both the tables
OutputDT = inputDT1.AsEnumerable().Where(Function(row) inputDT2.AsEnumerable().Select(function(r) r(“ColumnName”).ToString).Any(Function(x) x = row(“ColumnName”).ToString)).CopyToDataTable

Regards,
Rohith

[Ayman_Alabsi1 (Ayman Alabsi)]

try this solution

Sequence.xaml (7.5 KB)