Compare two columns from different sheets( same excel) and filter out Uncommon rows in separate spreadsheet

Compare two columns from different sheets( same excel) and filter out Uncommon rows in separate spreadsheet

@ayushi_jain3
Try this one after reading both sheets in different Datatables

dt1.AsEnumerable().Except(dt2.AsEnumerable(),System.Data.DataRowComparer.Default).CopyToDataTable

@ayushi_jain3 Check below attached thread and mark it as solution if it helps.https://forum.uipath.com/t/linq-to-compare-two-datatables-using-two-keys/231227

Hey, there is one more requirement in this. After taking out the unmatched rows in other sheet, need to delete those rows from original sheet as well.