Question

Problems with scientific notation and decimal notation

Forum|Forum|9 years ago
March 15, 2016
1 reply
167 views

phatnine

Hi guys,

After using an inline querier transformer, one column is now with scientific notation, and the other one with decimal notation. The problem is those two columns must not change format because they are used as primary keys in the database.

For example, one primary key is 10000000000000000000000 and it is showed as: 1.000000e+022. For the other column, I want this format 6745, but the inline querier formats it as: 6745.00. I want no special formatting because the joins in the database won't work.

I think I could add a string characterm such as a "_", before the inlinequerier and remove it just before writing to the database, but I want to know if there is a better solution.

Thank you,

Maxime

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.