Symptom
There is requirement to mass update data in the system. Some fields have more than one value, and needs to be updated via the tool.
Environment
SAP Sales & Service Cloud V2
Reproducing the Issue
- Download the relevant template from the Data Import and Export Tool.
- Open the template and add the data as required in the Excel File.
- There is a field with type ARRAY that can have more than one value.
- It is not known how to update multiple values for this field.
Cause
Multiple values need to be separated by a semicolon.
Resolution
For example, It is required to update values "AAA" and "BBB" for a specific field.
The solution would be to maintain the value as AAA;BBB in the file.
Keywords
Import, ARRAY, Multi Value, Sales, Service, Excel, Template, Values, Data , KBA , CEC-CRM-IMX , Data Import/Export for SAP Sales/Service Cloud , Problem
Product
SAP Sales Cloud and SAP Service Cloud Version 2 all versions