u/glintglib

How to delete duplicates in a master data entity

Hi I needed to import a couple of thousand new records in a master data entity (suburbs). I exported the current records then added in my new records. I goofed up and instead of importing via csv file from the that entity screen with allow duplicates turned off, I imported from the Imports screen and it has resulted in duplicates. I just cant flush the entity and re-import them all them all again as many are already referenced in other records. I can identify which of the duplicates are my new ones based on the create date but what is the easiest way to bulk delete these records (there is probaby 2000)?

reddit.com
u/glintglib — 4 days ago