Activity Forums Salesforce® Discussions How to remove duplicacy of data while importing Data using CSV file?

  • Sourabh

    March 22, 2016 at 1:41 pm

    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.

  • Ajit

    March 23, 2016 at 11:26 am
  • Parul

    September 18, 2018 at 6:24 am

    I think this may br help you : On the "Duplicate Email" column, create the following formula  =IF(C2=C3,"Duplicate Email", "Unique").





Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos