Import Error - Multiple records for Question exists in the table

[hanaphouse]

Can anyone help me understand this error when importing from excel into the question_choice table:

Here's the content of the excel file. It has one row for now but will import this with multiple records moving forward.

Here's the transform map:

I have checked the question_choice > Question = Location but currently, there are no records shown before import.

[Hitoshi Ozawa]

Just wondering if you're not importing the first row. Check if there's a record for a "Question" row.

I'm assuming that you're importing into an existing table and you're set Header row to 1.

Have you tried deleting the table and selecting to use "Create table" during the import or changing some values in the Excel sheet? It seems like the record already exists. Have you tried refreshing the list view?

[hanaphouse]

Yes, I am importing this into the out of the box question_choice table. This is not a custom table. I am unsure why the "Question" row would matter. Can you elaborate?

[Hitoshi Ozawa · Accepted solution]

Go to "System Definition" -> "Tables" and search for "Name" = "question_choice".

Open the table and you'll see that Question is of type Reference. You need to provide sys_id of a record in Question table instead of a String.