Reading multiplte Excel Files with different Table formats at once

KNIME Analytics Platform
1

Hello World,

lately I’m working on a workflow for a client that generates one excel table and needs two input excels. From those two excels I need for calculational reasons two sheets of each of them, because some formulas are referring from one sheet to another. My current solution is to upload each file and select each sheet. This means i have to run the excel reader four times. Is it possible to generate a loop, which would run those 4 different Excel Readers?

Thanks in advance,
Marian

2

Hi @MarianDu,

not quite sure what the problem is.
Do you have an example or screenshot how your workflow looks?

Is a simple loop over the Excel Reader not the solution? :thinking:
E. g. with the table row to variable https://hub.knime.com/knime/spaces/Examples/latest/06_Control_Structures/04_Loops/12_Using_TableRows_as_FlowVariables_in_Loop

1 Like
3

Hello @MarianDu,

and welcome to KNIME Community!

Yes, there is a way to read multiple files and/or Excel sheets using loop. Here is an example from KNIME Hub how to do it:

But loop is used when you are concatenating data from multiple files (which have same/similar structure) or data after processing. In your case you need each of your sheets as separate KNIME tables so having 4 readers seems the best option.

Br,
Ivan

1 Like
4

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.