I have two excel files: a master file and one that comes in on a regular basis by mail.
I need to append the master one with the ones that come in on a regular basis.
However, if there are duplicates, the user should be notified about which are duplicate and they should be removed.
Could you please tell me how you would approach this?
I tried with the following but I am not having a part where the duplicates are listed and returned to the user:
- Read range of the excel files that come in on a regular basis and store as dt
- Append range of the master excel file with dt
- Use activity remove duplicate range
Can you please tell me if this is a good way and how to add the part to indicate the duplicate ones that got removed?
Many thanks in advance