After importing data into the sys_choice table using Excel, the Value field is not populated correct

[Koki Sugimori]

After importing data into the sys_choice table using an Excel file, I am facing a problem where only the Value field is not populated with values correctly and all the values are replaced with numbers.

When I try with PDI, the data is imported correctly as per the Excel file, but in the demo instance, the Value field is all replaced with numbers.

Since the PDI is importing the data correctly, I do not think there is anything wrong with the Excel file itself.

My apologies if I have not explained it well enough.

Can anyone assist me with the above problem?

Best regards and thank you in advance for your help.

[Ankur Bawiskar]

@Koki Sugimori 

is this for state field?

If yes then usually state field has numbers in it choices depending on the field is on which table

Example:

if not then share some details?

why are you loading data into sys_choice table?

Why not create the choices manually in those fields

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Koki Sugimori]

@Ankur Bawiskar 

Thanks for the reply.

Not for state fields, but for newly created fields.

There are 5 newly created fields and we want to load data (choices) into each field.
The total amount of data we want to load is about 580 records, and we would like to do this by importing an Excel file, not manually.

[Ankur Bawiskar]

@Koki Sugimori 

field is of what type? string with choice or Choice type?

share field map screenshots for that Value column

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Koki Sugimori]

@Ankur Bawiskar 

I have created 5 custom columns in the Case[sn_customerservice_case] table.
The field type is Choice type.

Here is a screenshot of the value column in the sys_choice table.

Is this screenshot correct for your request?