Forum Discussion

RandyB's avatar
RandyB
New Member
9 years ago

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...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
9 years ago

For the purpose of testing, can you change the column type to text in Query Data modelling.

RandyB's avatar
RandyB
New Member
9 years ago

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.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    9 years ago

    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.