Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Integer field after extraction from MySQL DB shows E+ exponential value, HOW-to fix?

Hi folks,

Please have a look at the image below:

NumFieldIssue.jpg

After trying to to extract a table from MySQL db, one of the data fields got corrupted. Its an ID field, tried several methods to fix it but failed to solve the issue --> Num(), floor(), int() functions where used. Please advise. Thanks in advance.

Best Regards,

R

14 Replies
Colin-Albert

Have a look at this thread

number of 17 digits

Not applicable
Author

Thanks Colin.

Regards,

R

jagan
Luminary Alumni
Luminary Alumni

Hi,

If you are not using for calculation then try

LOAD

Text(Number) AS Number_Text,

*

FROM Datasource;

Regards,

Jagan.

Not applicable
Author

Thanks Jagan.

Warm Regards,

R

jagan
Luminary Alumni
Luminary Alumni

Hi,

Can you close this discussion.

Regards,

Jagan.