-
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
An Ultimate Guide to Salesforce Flow Builder User Interface
Toolbox - The toolbox contains the factors and resources you use to build your go with the flow. From the Elements tab, add new factors,…
Modernize your Business with Salesforce hasten Applications
Salesforce is the world’s largest customer relationship management(CRM) tool provider which allows companies to connect with their customers in a completely new way. The CRM…
Integrating Google Maps with Salesforce - All You Need to Know About
In this blog, we learned how to use the MARKER API to integrate Google Maps with the Salesforce. An area on a map is designated…
Popular Salesforce Videos
Rollup Trigger via Salesforce Record Triggered Flow - Trigger without code
Hello Folks, I created a Rollup trigger via Salesforce Record Triggered Flow (without code cool isn't). I use Record trigger Flow for that scenario. There…
Add Intelligence to Any Salesforce App with Einstein Discovery
Bring intelligence in the context on any Force.com app thanks to the power of Einstein Data Discovery. Any Salesforce Admin or Developer can add in…
Getting Started with Salesforce Lightning Process Builder
Process Builder is a point and click tool that makes it easy to automate many common Salesforce tasks. Learn how to design and build effective…
