Issue in String to number Conversion

KNIME Analytics Platform
#1

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)

#2

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
#4

This works without errors in KNIME 4.1.2

image
image545×566 5.44 KB

3 Likes
#5

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

2 Likes
#6

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

#7

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

#8

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