Requirement:- we need to convert a multi-select picklist value into single select picklist value.if We change the Multiselect to Single .how we can avoid data loss
-
If there is record that currently have 3 picklist values, how do you want to convert it into single value?– Liron CCommented Nov 3, 2016 at 4:55
-
Yes that is the business requirement.I already Explained its not possible ,but posted for any solution/workaround.– demCommented Nov 3, 2016 at 4:59
-
You can suggest that in case record have more than 1 picklist value, then you will put there only first value (after changing it single picklist). If it's fine, use the solution Sharvan suggest below. If it's not, require conversion logic from the person who raise the requirement– Liron CCommented Nov 3, 2016 at 5:04
Add a comment
|
1 Answer
We will be losing data if Changing from multi Picklist to any other type. It's not possible to avoid while conversion but we can do with apex data loader with minimal risk.
- Take a backup
- convert to picklist
- Remove multi select to single value in csv file with respect to your requirement
- upload into salesforce.
-
Now the Requirment is The Value listed First in Mulitselect for perticular record needs to be set in single Picklist after Changing to Single Picklist. Is there any option to set fist value in record when we convert multi select to single picklist.Please suggest– demCommented Nov 3, 2016 at 6:03
-