Uploading to Multivalued List using Data Workbench

[former_member263658]

contact-lob-error.png

Using the update function in Data Workbench, we are trying to load multiple values to a KUT Multivalued List field.

Is this supported? If so, what would the correct formatting be to load the multiple values. We have tried to load it in various formats, only to receive the attached error each time.

Field Code values are as follows:

01

02

03

04...etc

Thanks,

Don

[VishnAndr]

Hi Don,

01,03 will work 100%. E.g. comma-separated list of your codes for multivalue list field. If you open CSV file in notepad or any other text editor, the value actually will be "01,03" as an example.

You can even pass any values (like description instead of code) in the file. Then you will need to do the code list mapping during the Import to match your values in the file with codes.

Your error comes from the data. Which format/values did you use to maintain the field? What do you have in CSV file for this field?

PS: the usual pattern I'm personally using is: maintain a sample data in any instance of the object -> export this one instance via DWB -> look into the file exported -> maintain the same or similar in the import file -> import the file.