I am trying to convert a string column (0.0012; 0.00000418; 0.0005…) into a number. When I use the conversion node “String to Number” I get a column with (0.001; 0; 0.001…).
How can I convert to (0.0012; 0.00000418; 0.0005…) that are considered as Real?
Welcome to the KNIME forum.
It seems you have more then 1 value in the column. So you need to split it in number of columns using
using ; as delimeter. Then unpivot result table, then using String Manipulation node function ToDouble() convert strings to numbers and finally pivot it back in line, if you need.
This seems like a rendering problem in KNIME - what version are you using? I see the same behavior as you describe in 4.0.1, but it’s a red herring - the double values are actually there as can be seen in the output of the Java Snippet node in the attached workflow - it is just that the output table renderer is rounding / truncating the display of double values. delphine’s numbers.knwf (7.5 KB)
@dcollin1 i had no idea this was there, but if in the output data table view, you right click on the column header for the Double value column, there will be a context menu with an item titled “Available Renderers”. Under this you can choose Full Precision which will show you non-truncated values.