"string to number" yields round double?

KNIME Analytics Platform
#1

When applied "string to number", I got

input           output

0.0001        0

0.000625     0.001

It seems the outputs are automatically rounded to 3 significant numbers after decimal. How can I turn off the round function? Or is there another node can keep all digits in the conversion? thanks.

#2

All the digits are actually there -it is just that the default Double Cell rendering is to only show a maximum of 3 decimal places.  If you right click on the 'D' in the column heading, you should be able to change to see the full number

Steve

1 Like
#3

You should also be able to use the "Round Double" node to set however many decimals places you want

#4

Thank you Steve! I didn't know the redering function in node output view.

Thank you Andyg for sharing!

My problem is solved.