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
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