function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ganeshjjganeshjj 

Can we prevent duplicates while working with data loader?

any body can help me please..........?

 

Rahul_sgRahul_sg

You can provided you have added validation rules or apex code to detect the duplicates in your org. There is no in built dup detection feature available.

 
AroraAnupAroraAnup

Natively, Data Loader does not offer a de-dupe feature that would error out duplicate records when you insert data in SFDC using the data loader. You may want to use the Unique field property to define one of the key fields in your object as Unique, so that when you are inserting data into this object, the system identifies duplicate entries into this field. However, this will only work based upon how the data has been prepared, and may not be a full-proof solution.

There are a host of tools and apps available on the AppExchange that you can explore for preventing duplicate data being entered into SFDC. Some are free while some are paid (of course the paid ones will have additional capabilities)

Good luck!
souvik9086souvik9086

Do you mean preventing duplicates on the basis of a particular field value? I' afraid this can't be done through dataloader. What you can do is to create a trigger or validation rule to perform the de-dupe check on the basis of that field value.

 

If this post is helpful please throw Kudos.If this post solves your problem kindly mark it as solution.

Thanks