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
Conversion Factor
-
pradeep.k.jagadeesan
- Posts: 28
- Joined: Tue Jun 16, 2009 1:03 pm
- OLAP Product: IBM Cognos TM1
- Version: 9.5.1
- Excel Version: 2007
- Location: India
-
Martin Ryan
- Site Admin
- Posts: 2000
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: Conversion Factor
In the variables tab of the TI process you will have this column marked as "Numeric", change it to "String".
Martin
Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer