-
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
Why Having a Preference Center is Key to Your Email Marketing Strategy | Salesforce Marketing Cloud
As Marketing Technology consultant, DemandBlue interacts with many digital marketers. Our team audits the full range of digital marketing assets that organizations manage. Based on…
Upcoming Market Trends in Salesforce CRM
“SALESFORCE has reached a long distance since late nineties. That was the time, when people use to consider it as a business tool for Salesforce…
Public Groups in Salesforce - The Complete Developer Guide
A public group can be defined as a collection of individual users, other groups, individual roles, and/or roles with their subordinates that all have a…
Popular Salesforce Videos
Salesforce Customer 360 Data Manager
Salesforce Customer 360 Data Manager is a cross-cloud integration capability that allows Salesforce admins and developers to combine and reconcile customer data from their Salesforce…
Salesforce Platform Quick Tip: How to Use Einstein Search
Want to improve your searches in Salesforce, and make them faster and more intuitive? In part one of this 2 part series, Trailblazer and Salesforce…
Salesforce Business to Consumer (B2C) Solution Architecture
Salesforce Business to Consumer (B2C) Solution Architecture Introduction, 05 min -Case Study – A Retail Company Journey -A need for Multi-Cloud Solutions -Salesforce B2C Solution…