Why the zero digit will lose?

I have a txt file, which the student id is 00135… smth like that.
After importing to Knime, all 0 losed.
The id turns to be 135, 138

How can I fix it?

One way could be to use R readr and force the column to be imported as string.

Or maybe there is an advanced setting in the file reader node.

1 Like

If you are using the File Reader, you can right click on the StudentID column in the preview pane and force it to String prior to executing the node. Does that work for you?

6 Likes

you can just use the normal csv reader with scan limit 0 to force all string :+1:

@HKuser that should fix your number problem :slight_smile:

2 Likes

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