How to read multiple excel files in one folder?
Hi, I want to use below knime flow to read 2 excels in one folder and combine them into 1 speed sheet in a new excel. the two input excel had same template and header. But when execution, there is always an error showing as below:
Execute failed: Input table's structure differs from reference (first iteration) table: Column 7 [Delivery Q (Number (integer))] vs. [Delivery Q (Number (double))]Column 9 [Gross Weig (Number (double))] vs. [Gross Weig (String)]
So, how can I change the table structure to ensure two tables have the same characters? thanks for your help!