-
How to remove duplicacy of data while importing Data using CSV file?
How to remove duplicacy while uploading data through csv file while using Data import wizard and don't have any unique field? I want to use Email as primary key to import the Data but two different data can have same Emails. The data can be removed while importing which have same Emails.
-
3 Replies
-
You can create a custom field named Email(text) and make it "UNIQUE" as well as "EXTERNAL ID". Now while importing Data through Data import wizard map the custom
Email field with the Email present in csv. This will remove the duplicacy problem.
The records having different Email will be inserted also the records having same Email will insert but only one record from different data having same Email will be inserted.For example suppose you have 4 records which have same email then while importing only one record from all 4 will be insert on priority basis which will come first while importing data.
Hopefully it will resolve your issue.
Thanks -
Please have a look into this link
https://help.salesforce.com/HTViewSolution?id=000182414&language=en_US
-
I think this may br help you : On the "Duplicate Email" column, create the following formula =IF(C2=C3,"Duplicate Email", "Unique").
Thanks
Log In to reply.
Popular Salesforce Blogs
Salesforce Service Cloud: Streamlining Customer Service Operations
Today's fiercely competitive business environment makes offering outstanding customer service more than simply a choice—it's a requirement. Customers now demand individualized, prompt, and effective service,…
No Code MuleSoft Composer Integration with Salesforce
MuleSoft Composer is the first integration tool embedded in the Salesforce platform and offers a declarative interface to making integrations. It can directly integrate with…
Revealing the Hidden Costs of Salesforce Implementation
Could your Salesforce implementation be costing your company more than anticipated? Throughout my experience as a Salesforce consultant, I've had the opportunity to assist clients with…
Popular Salesforce Videos
Emails and Cases in Salesforce Lightning Experience
In this video, Jodie Miners gives an in-depth look at some of the features and potential issues with emails in cases in Lightning Experience. He…
Exploring Technology Choices For Salesforce Integration
Are you struggling to find the perfect technology to integrate Salesforce into your business processes? Integrating Salesforce into your business processes can offer significant advantages,…
Work.com – Release Readiness LIVE, Summer '20 | Salesforce
Work.com is an online set of applications, resources, and content designed to help the entire workplace get back to business after the Covid-19 crisis. This…
