Dynamically reading sheets in an Excel file
Hi.
I am a data scientist apprentice who has just started working with Knime.
I am trying to build a flow to dynamically read all sheets in an excel file using a loop.
I have set the flow variable in the excel reader to sheet which corresponds the differing sheet names in the read excel sheet names node.
The issue I am having is the my flow is reading the first sheet 5 times rather than reading the first sheet, second sheet, third sheet etc.
What I am left with in the end is a table showing my fist sheet unioned 5 times.
Here are some screen shots: