Hi,
i tried to change the “PVO” in my Excell Table from String to Number, but when i use “String to Number” node, all the results are missing values. could someone help me ?
this is my workflow
KNIME_project.knwf (74.1 KB)
thanks
Br,
Hussein
Hi,
i tried to change the “PVO” in my Excell Table from String to Number, but when i use “String to Number” node, all the results are missing values. could someone help me ?
this is my workflow
KNIME_project.knwf (74.1 KB)
thanks
Br,
Hussein
You need to get rid of currency sign and dashes first.
Hi, the most easy way is for you to do some string manipulation , use the replaceChars function for each price or do a loop through the columns.
replaceChars (PVOcolmnhere,“€, -”,"")
this will replace the euro, comma space and dash signs with nothing, then you can convert to number.
hope it helps.