Issue in String to number Conversion

Hello Knime Expert,

I just need some help.
When I am converting Column Using node: String to Number
It is showing following error:
" Values in 11790 cells could not be parsed, first error: ‘17.52’"

I have shared Excel file for conversion.

Export Script 3.xlsx (76.7 KB)

Hi - It would be more helpful if you shared a screenshot of the output from the node providing input to String to Number node, and the configuration dialog of the StN node as well.

1 Like

This works without errors in KNIME 4.1.2

3 Likes

Hi
check thousands separator as below under string to number config:
image

2 Likes

Thank you So much.
My issue has been resolved, using this.

Thanks for the reply, I just missed out thousand seperater…
I got answer.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.