Error Message: "Multiple values found for a dropdown field that can only take one. for field XXXX" in Field Mapping Section of the Import Assistant

User is updating the Category field of customer records. Sample CSV file:

Internal ID	Company Name	Category
167	Company 1	Retail
168	Company 2	Retail |
169	Company 3	Wholesale

 

In the field mapping section, after mapping the fields, when user clicks Next, the following error is returned: Multiple values found for a dropdown field that can only take one. for field "Category"

To resolve this error, perform the following steps:

     1. Open the CSV file.
     
     2. Check the column specified in the error (e.g. Category).
     
     3. Check if there is a row that contains a Pipeline Character (|), in this example, the second row.
     
     4. Remove the Pipeline character.
     
     5. Save the CSV file.
     
     6. Re-import using the updated CSV file.
     
Note: Pipeline character is used for Multi-Select field. Since the field being updated is a List field, NetSuite returns the error since a list field can only take one value.