-
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 - [adinserter block='9']
-
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
Delegated Authentication Single Sign-On in Salesforce. How to achieve this with Okta?
Delegated Authentication Single Sign-On - We can configure our Salesforce org with any authentication method of our choice using this feature of salesforce. We can…
Facebook Salesforce Integration: Why You Should Care and How it Is Suppose to Be
Do you put your best efforts into improving business outreach, customer acquisition, and growth, but outcomes are not always as they should be? Then you…
Understanding the role of Salesforce Consulting in Driving Digital Transformation
In today’s rapidly evolving business environment, digital transformation has become a critical priority for companies across all industries. Digital transformation integrates digital technology into an…
Popular Salesforce Videos
A Walkthrough of Visual Configuration
Whether you manufacture building, furniture, or industrial products, our product configurator guides your customers in making better purchase decisions. These 3D visualization technologies used in…
Getting Started With The Ant Migration Tool in Salesforce
Ant Migration Tool In Salesforce. In this video, the following points will be covered - 1. Introduction Get a brief introduction about the Ant Migration…
How To Filter Salesforce Reports via URL Parameters - Learn Salesforce Series By Algoworks
How To Filter Salesforce Reports via URL Parameters In this video, the following points will be covered - 1. Introduction Get a brief introduction to…