I was working on a new TI process today and got this error – “Cannot convert field number 9, value “*textdata*” to a real number”.
Odd, I thought. Cryptic error – cannot convert field number 9! I initially thought it might concern field number 9 in my source data. Nope. No cigar!
What this TI field error is saying is that a field on the Variables tab has been defined as numeric when it should have been string.
To resolve the error “Cannot convert field number 9, value “*textdata*” to a real number”, go define the offending field (not field number 9!) as String on the Variables tab in your Turbo Integrator process and viola!