How to Read an Excel File with different Sheets correctly?

[Julez]

Hi,
i have followed the routine for this task, but don´t get the result i would like to have

My Example ist i have the following Excel File with two Sheets:

But I always get Sheet 1 doubled as output:

Would be great if someone could help me
Greatings
Julian

[bruno29a]

Hi @Julez and welcome to the Knime Community.

This is because you are reading the same sheet twice

You have to set the sheet variable to the sheet name. As it stands, you are sending the file variable to read the file, so you end up reading the file twice and reading the same sheet.

So, the first thing to do in your Excel Reader is to choose the option “Select sheet with name”:

Then go to the Flow Variables tab, and assign your variable to the sheet_name variable:

One additional information. If your sheets have different columns, the Excel Reader might complain. In this case, use the “Support changing file schemas” in the “Advanced Settings” tab:

EDIT: Also, please avoid using deprecated nodes. Deprecated nodes mean that they have newer versions that should be better or have new features, which you can take advantage of. Also, deprecated nodes are removed in newer versions of Knime

[Julez]

thank you for the warm welcome and for solving my problem

[bruno29a]

No problem @Julez , happy to help