Compare if rows in a sheet is the same values with rows in another sheet "b"

Hi devs, I would like to compare if a row in sheet “a” is the same value with row in sheet “b” ,if true, remove matching rows from sheet “a”. Please assist

1 Like

Hey @RPA-botDev

Read the sheets and store it in Data Table

ForEach row in dt_Sheet1.AsEnumerable

   IF dt_Sheet2.AsEnumerable.Where(Function(obj) obj("Column").ToString.Equals(row("Column").ToString)).Count > 0

       Remove Data Row


       Do Nothing

Hope this helps


1 Like

Thanks NithinKrishna. Regards

1 Like

Perfect @RPA-botDev cool :innocent::+1:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.