TM1 Forum

While uploading a CSV file through TI process, I am getting an error saying Cannot convert field number 12, value "10,231 EA" to a real number.

Actual data in this column is number. But when the CSV file opened, it shows as different conversion ex. 12545E+11. Will it cause this issue?

Please reply.

Thanks
Pradeep J

In the variables tab of the TI process you will have this column marked as "Numeric", change it to "String".

Martin