Excel reader is not executing because not all columns are contained in all sources although I am using a loop

[takbb]

Hi @wuhnderess , take a look at this post (and the post that it links to), and see if the info there helps you

read multiple excel file with different structure

Hi @alrz , this is going to get much depend on your files and just how different they are. For example will the columns that are the same be in the same order? Are the column names consistent? Does the combination of all the excel sheets make sense to be in a single table? Where there are differences in the files, what do you want the resultant table to look like? Here is one topic with suggestions that may be of help: Putting the Excel Reader in a loop may also be an option…generally for…

I suspect that setting the options for what to do when the “file schema” changes, on the advanced tab of the Excel Reader will be part of resolving your problem.

How this option appears will depend on your version of KNIME as the Excel Reader advanced tab has changed a little over time. Which version of KNIME are you using?