Hello community!
I’m new to Knime and I’m trying to import a file, but the field that is 0.01 and 0.03 is becoming .01 and .03, does anyone know why this happens?
Do you have any solution?
First of all welcome to the world of KNIME.
The given information is not really full of information.
What node are you trying? Is this the File Reader Node?
What I can see from the screenshot giving me some first ideas::
- Except col. 3 “Adic Frac” all columns have the type String. You can see this from the [S] ahead the column name in the preview.
- The decimal seperator is the dot “.” but the read strings e.g. in “Valor C” have a comma “,”
So first of all adjust the comma seperator.
Furthermore you can try to enforce the correct type in the tab Transformation.
Maybe you can share the input data or a suitable sample.
1 Like