Support Portal

for ProcessRobot and WinAutomation

Start a new topic

Remove duplicates from two Excel files efficiently

ADMIN

The attached process prompts the user to select two (2) Excel files. It removes from the second file all the rows that can also be found in the first.


As a result, we have two (2) Excel files with unique and different rows.


Note: The process can be modified depending on the column size of the relevant excel file.


Check this article for more info on how to execute SQL queries to Excel.

xlsx
(9.32 KB)
xlsx
(8.33 KB)
waj
Login or Signup to post a comment