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 

can you make the field type as Choice instead of String?

Also ensure the import set field which holds the value should be of type String and not Integer

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

[Shivalika]

Hello @Koki Sugimori 

If possible share some screenshots. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[Koki Sugimori]

@Shivalika 
Thanks for the reply.

Below is the Excel file.

This is a preview of the import into PDI's sys_choice table.
The data in the Excel file has been imported correctly in Value.

The following is the preview screen when imported into the sys_choice table of the demo instance.
Value is changed to a number.

[Shivalika]

Got it @Koki Sugimori 

Are these fields values stored anywhere in the form of numbers ? Where display value is this but backend value is a number ? 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[Koki Sugimori]

@Shivalika 
＞Are these fields values stored anywhere in the form of numbers ? Where display value is this but backend value is a number ? 

Excuse me.
Can you please let me know how to check this one?