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?
[SalesForce] Multiselect picklist – dataloader
Related Solutions
Based on the documentation, it seems to be normal to get this string containing a series of attributes delimited by semicolons.
Multi-select picklist fields contain a list of one or more items from which a user can choose multiple items. One of the items can be configured as the default item. Selections are maintained as a string containing a series of attributes delimited by semicolons. For example, a query might return the values of a multivalue picklist as “first value; second value; third value”.
http://www.salesforce.com/us/developer/docs/api/Content/field_types.htm#i1435691
Yes, You can update the Second Multi Pick list Values based on First Multi Pick list Value using Process Builder.
Step 1 : Set the condition based on the Value from Multi pick list One
Step 2: Use the Update Records action and set the Second Multi Pick list Values
Best Answer
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.