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?
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
Hope this helps
Activity used: Database activities, SQL commands.