When am trying to update contacts using Dataloader then multiselect picklist values for existing records gets overridden.I want values to be added to current multiselect picklist without overriding values with what I have on the existing record.Is there a way to do this?

  • 3
    I believe the only option here is to pull the data and merge picklist values – o-lexi Nov 9 '17 at 18:04

You need to create 2 set of csv where the first csv contain those contacts where you want to override picklist values.

And in second csv if the picklist column is still there in the csv file, you will not map this column during update.

Salesforce dataloader doesn't have a provision to decide dynamically which values to be overridden. It just updates ALL values which are getting mapped.

| improve this answer | |
  • Then how do we update new picklist values to existing records. – sfdc Nov 9 '17 at 16:02
  • In the first csv where you want to update picklist. basically if you map the csv column with salesforce fields then during loading it updates the values. – Santanu Boral Nov 9 '17 at 16:34
  • exported data with Id column aad picklist values column

  • Edit exported file and add new value to existing value separated by semicolumn (;)

  • Uploaded edited file back using data loader

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.