CSV Reader node

KNIME Analytics Platform
#1

When I have columns with numeric content that has 19 digits then the CSV reader tries to convert it to double and the content is incorrect. Example where the last 2 digits of the second row are read incorrectly (…770):
“text”,“id”
“abc”,“34545454”
“bla”,“1234567890123456789”

How can I avoid / fix that?

#2

You can double click on the column header in the node configuration and specify a different type.

#3

Use File Reader instead. It has a column type configuration on preview. Then you click on a header menu with types popups.

2 Likes
#4

Whoups. @izaychik63 is entirely right, my answer was targeted to File Reader instead of CSV Reader.