How can I delete duplicate records if they were all added at the same time?
Eliminate accidental duplicate records.
Forum Discussion
How exactly do you know they are duplicates after the fact? Ideally - you would want to try and stop the original entry from happening - so think about unique fields so users can't create dupes in the first place. Are these being entered via grid edit or import?
If setting up a unique field to stop the entry isn't an option - you'll need a way to actually identify systematically which ones are dupes before you can look into deleting them.
Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
If setting up a unique field to stop the entry isn't an option - you'll need a way to actually identify systematically which ones are dupes before you can look into deleting them.
Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
- I typically do stop this from occuring but this time it did. I think I was working in MS Excel too long and too late one night.
There are hundreds of dups and identifying one at a time is taking too long. I just need this fix for this 1 situation, not ongoing. - Per the comments from Coach - you could set up a summary report to group / identify your dupes and drill in to each grouping and mass delete that way from his comments. Honestly though - you could just line them all up from the day you imported them and just delete them by clicking the delete box from a report, and just going through to check the ones you want deleted. There isn't really a flashy way to do deletions at the end of the day
Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base