Get Common rows from 2 tables to Resultant table and other manipulation

Hi @RobotReader

Welcome to Community!!

’ Find common rows
commonRows = Table1.AsEnumerable().Intersect(Table2.AsEnumerable(), DataRowComparer.Default).CopyToDataTable()

’ Find unique rows in Table1
uniqueRowsInTable1 = Table1.AsEnumerable().Except(Table2.AsEnumerable(), DataRowComparer.Default).CopyToDataTable()

’ Find unique rows in Table2
uniqueRowsInTable2 = Table2.AsEnumerable().Except(Table1.AsEnumerable(), DataRowComparer.Default).CopyToDataTable()