Skip to main content
Question

Problems with scientific notation and decimal notation

  • March 15, 2016
  • 1 reply
  • 131 views

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

1 reply

koen
Contributor
Forum|alt.badge.img+10
  • Contributor
  • March 16, 2016

What Type did you selected for the columns inside the InlineQuerier?

I think when you choose text there, it will work.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings