This sounds easier than it is. I have to read files with an unknown number of columns and an unknown name of each column. I need KNIME to read all these columns as strings. Example, when reading one file with postal codes from the US, it decided the column was an integer because there was no alpha-characters. In the process, postal codes with leading zeros are damaged. So I can’t convert them to strings after the read. This is easy to do with CSV Reader and File Reader if you know the name of the columns in advance. But since I don’t know the column names in advance, I would have to change the File Reader configuration manually for every file submitted. That’s no an option. Anyone else had to solve this problem?

Force KNIME to Read CSV Columns As Strings

mlauber71 June 18, 2018, 4:57pm 2

You could try and combine this approach - using R package readr

with this thing:

The package seems to have the option to force all columns to strings.

KNIME External tool - column type detection

Simple Workflow to Append New Weekly Data To Prior Weeks

ERROR: row is too big: size 9592, maximum size 8160