Excel Reader Multiple Files Fails

[mlauber71]

You could use R to force all columns to first be imported as strings and convert them later after you have consolidated them.

Excel Reader Problem

Here is one example how to read different excel files with the help of R and let some logic decide what type a column is. Maybe this could help. I think the KNIME Excel Reader mostly expects the column number and types to stay constant (or it will throw a warning). [image] Or you would have to disable the preview in the Excel reader and see if that stops the messages, with the mentioned downsides. [image]

You could also try and turn off the preview that would report the different types but you still might encounter problems later when bringing the data together.