Hello everyone, i encountered a strange behaviour in KNIME. I have two identical excel files with identical sheets, the only difference is the year. In sum the there are 14 sheets from which i need only 12 (month in a year). I used the normal basic workflow for extracting and joining the sheets. With the excel file for 2021 everything works fine as expected. But when i go th 2020 (and i cant stress this enough out) which has a identical layout, KNIME moves a column on its own, which then leads to an error… I dont understand why KNIME does this… My workflow: [workflow] The original order from the excel sheet and how i wawnt to keep it (which works perfectly fine for the first file) [excel] But KNIME is putting one column to the very end (and changes it to “integer”) during the process… [knime] which then leads to the error message: “Input table’s structure differs from reference (first iteration) table” I already tried to make a new sheet in the excel file with the same data, i did various formatting in the sheet, tried different setting in KNIME, but nothing helps… Can someone tell me why KNIME is moving the column? Kind regards Stephan

KNIMe rearranges column on its own

mlauber71 January 6, 2022, 5:13pm 2

@Stbin you might have to check the advanced tab of the excel reader

2 Likes