This is probably a basic question but I’m not really sure how to get rid of this problem.
I have an input file with some codes, these are taken by Knime as Double, when I use Number to String node to transform the values to Strings then I get the below output
Original Value:
4,015,400,550,433
After Conversion:
4.015400550433E12
How can I get rid of the E12 that’s being added to all values? I just want to have the full number but as string.
Not sure why above happens but if you use Long problem is solved. I would say number length.
You can use Column Expressions node and toLong() function with String as new column type
Ivan
But removing “E12” still leaves wrong value (4.015…) Right?
Seems operations on double numbers work up to 7 digits. If there is more digits they are transformed to decimal and “Ex” is added where x is number of decimal places…
Br,
Ivan