I have two excel tables with the same headers, I want to compare them and remove duplicate data.
In one of the tables it contains all the execution history and in another table it contains the data that I want to check if they have already been executed through the column “Protocolo”. This column contains a unique numbering and therefore I will use it for validation.
If the data in that column is in the first table, then I want to remove it and leave only the data that was not previously executed.
Attached, the main file of how I am trying to solve this problem, but without success and also the two worksheets I am using.
PS: My apologies if my English is not spelled correctly, I am Brazilian lol.
UiPath.zip (48.3 KB)