How to delete duplicate records in Salesforce? - Forcetalks

Tagged: Account Object, DML Operations, Duplicate Management, Duplicate Records, Salesforce Objects, Salesforce Records

Salesforce® Discussions

How to delete duplicate records in Salesforce?

Posted by Ankit on January 10, 2018 at 9:26 AM

As I have inserted so many duplicate records in my account object could not find a way to update them via DML?

Archit replied 8 years, 4 months ago 3 Members · 3 Replies
3 Replies

Piyush

Member
January 10, 2018 at 9:47 AM

Hi Ankit,

How you identify that the record was duplicate. Can you please explain more on that.
[adinserter block='9']
Ankit

Member
January 10, 2018 at 10:14 AM

Hi,

As the values in the fields are same such as their names.

for reference consider this image,

Hope this will help!
Archit

Member
January 10, 2018 at 10:27 AM
Hello Ankit,

If you consider duplicate’s in terms of name or any particular field of any object might be the below code would be helpful to get your answer. I tried below code to remove duplicate name records of Accounts object.
```
List<Account> fullList = [Select Id, name From Account limit 200];
Set<String> orderObj = new Set<String>(); 
List<Account> dupList = new List<Account>();

for(Account a : fullList)
{
 if(orderObj.contains(a.name))
 {
 dupList.add(a);
 }
 else
 {
 orderObj.add(a.name);
 }
}

delete dupList;
```
Hope the answer would be helpful!!

Log In to reply.