Question

Problems with scientific notation and decimal notation

  • 15 March 2016
  • 1 reply
  • 29 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

Badge +6

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

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

Reply