I have CSV files that I am reading in with the ‘CSV Reader’ node, and I noticed that the table it produces does not exactly match the data in the file itself. Specifically, in the file itself all numbers are entered to 7 digits past the decimal yet in the table that is produced by CSV Reader I see only 3. If I look at the column spec for the output from CSV Reader it also shows these to have only 3 digits past the decimal. I don’t see any obvious parameters in CSV Reader that I can change to change this. Can someone shed some light on what is going on? Should I use a different method to read in these CSV files to retain the full numeric precision that was in the file?

Numeric columns are only cut to three digits in the table view. Internally still all digits are stored. You can change the display by right-clicking on the column header and selecting a different renderer. There should be one for full precision.

Does CSV Reader truncate values?

KNIME Analytics Platform

mlauber71 February 4, 2019, 6:55pm 4

For more complex imports I use the R package Readr which seems to be quite robust and has a lot of configurations going for it.