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

Help Forum
,
1

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
2

https://www.google.com/search?q=uipath+compare+two+sheets+site:forum.uipath.com&safe=active&rlz=1C1GCEA_enUS956US956&sa=X&ved=2ahUKEwjz1PLP16X3AhXjoWoFHUfgCr4QrQIoBHoECA8QBQ&biw=1920&bih=977&dpr=1

3

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

   Else 

       Do Nothing

Hope this helps

Thanks
#nK

1 Like
4

Thanks NithinKrishna. Regards

1 Like
5

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

6

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