CSV Reader Data Types Error

Hi,

I am having issues loading in a csv file using the csv reader node. I am getting an error saying 'row56806 can’t be converted to the configured data types.

I have tried de selected ‘enforced data types’ .

Does anyone know how to get passed this?

Thanks.

Hi @finspencer246,

You can configure the CSV Reader to treat all columns as strings temporarily by unchecking “Enforce Data Types” and forcing KNIME to import every column as a string. This way, you’ll be able to load the file without errors and can later convert columns to the correct types using the “String to Number” or similar nodes.

Regards,
Yogesh

2 Likes

lovely, thanks yogesh! I realised if I selected read all the data in rather than the first 10,000 it also worked.

1 Like

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