Forum Discussion
Cannot covert a 9.99e+11 value to integer
I've imported key integer field from a SQL database and the value is 999000024011. The Grid is showing the imported value as 9.99e+11 in this as well as the subsequent fields. The susequent fields ho...
For the purpose of testing, can you change the column type to text in Query Data modelling.
Thanks Parry. It did change it to show the value but when I converted it back to a whole number, it converted it back to the exponential format. this will be a problem when I join the tables on the fields.
That is a great suggestion.
Randy.
Until someone provide what is the exact solution, can you change datatype to text in both tables and join on that, that will get you going.