How to remove a row a row in one excel by comparing in another excel

Hi There,

I am trying to remove a data row of 10 columns in excel A and comparing with the data of excel B with 3 columns. If the data in column 1 of excel B present in the column of excel A. I want to delete the data in Excel A.

I tried:

Creating two data tables DT1 and DT2 and used activity remove data row.

Data is not deleting. Any help is appreciated.

Thank you.

Hi @Balesh, Let me know if this doesn’t help " How to delete data row of one data table based on other matching data row of other datatable? - #7 by samir "

1 Like

Hey @Balesh, I’ve just created this video tutorial for you - UiPath | Compare Two Excel Sheets (/Data Tables) and Delete Matching Rows | Tutorial - YouTube

1 Like

Thank you AndersJensen. It helped me solve my problem. I appreciate it.