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.

[Koki Sugimori]

@Ankur Bawiskar 

Thank you very much.
So, am I correct in deleting the column in the red frame in the image below and re-creating the Value column with Type=String?

Also, when you delete the column, is there any effect on the existing records in the sys_choice table?
I would also like to know if there are any precautions to be taken.

[Ankur Bawiskar]

@Koki Sugimori 

no impact in existing sys_choice table

You will have to map this new field again in transform map with the correct Value field from sys_choice

It will start working fine.

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