Forum Discussion

iannes's avatar
iannes
New Member
8 years ago

Scientific notation is being read as text

I need help, my data source has numbers like: 2.0356e+3 and 3.40685e-4 They are being read as text and changing the collum type in query editor is not working How do i turn them into something Powe...
MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi iannes,

 

When you change the data type in the query editor what result do you get and error or your number convert to an integer?

 

Regards,

MFelix

iannes's avatar
iannes
New Member
8 years ago

Hello MFelix

 

I solved the problem using Parse as Json, I managed to apply this to all columns , my  new question is if there is a way to automaticaly do this when I get new data in other tables.

 

Thanks for the support!