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.