Excel reader showing inaccurate results

[paumanuela]

Hello! I created a workflow that is being run several times using different excel sources. Each time we execute the workflow, we manually change the source tables used. The problem is that when I change the source, the Excel Reader node reflects the table dimensions of the source that was used before instead of the current one. This leads to the output of the Excel Reader either missing several columns (if the previous source contain less columns than the current) or including empty columns. Is this an issue with the cache? I’ve already tried changing the option to 'Write table on disc" but still encountering the same issue.

[mlauber71]

@paumanuela welcome to the KNIME forum. You will have to allow changing file schemas in the settings

Union multiple excel files with different columns

Hi @danielkataoka , there are a couple of ways to go about this, but it’s hard to tell without seeing the structure of your files. There aren’t much you saying. As I always say, the more info you give, the more precise the solution you will get. “Help us help you”. So, are we to assume that you want to keep only the columns that exist in all the files, or should the ones that don’t have the additional columns to be filled with EMPTY values? If it is the former, how are the files with more co…

[paumanuela]

Thank you so much! This totally fixed the issue I had.