Consolidate multiple excel sheets into one

[chimdee]

Please disregard. I found that this type of error is a known issue with the new excel reader.

Excel reader transformation problem

Hi, With Knime 4.3 I found a problem using the new excel reader in a loop. I have multiple table Excel table with the same structure that I need to consolidate (through a loop), but the problem with new excel reader is that for my first table the amount column is read as an Integer but the second table in the loop the amount is defined as Double which cause the loop to fail at the excel reader level as is it can’t read the Double as Integer. Even with the enforce type unchecked, the loop fail, …