How to use RPA to match the records from mutiple excel sheets

I have large history datasets, i need RPA to do a comparison/matching between the past records and the current records. If the new records doesn’t match with past records, bot will highlight it to the users.

What activities i can use?

hi @Wendy_wendy,

If you have a Database/DT for this whole this, i’ll suggest do a select query on it and look if it return a row count = 1.
If yes, you have it already present in past else you can highlight it to the user :slight_smile:

Hope this helps :smiley:

Activity used: Database activities, SQL commands.