Hello!
I’m working on a workflow where I want to read multiple excel files with the same format and extract certain fields so we can create a data base with that information? Any ideas on how we can create a loop flow?
Thanks!
Hello!
I’m working on a workflow where I want to read multiple excel files with the same format and extract certain fields so we can create a data base with that information? Any ideas on how we can create a loop flow?
Thanks!
Hi @lgarduno
you can start with some of the examples in the forum:
e.g.:
how to read specific sheet from multiple excel files in a folder
Then just filter for your needed fields either at the end of the loop or after the loop
Hi there @lgarduno,
Just to add that with new Excel Reader node (available from KNIME version 4.1.0.) you can read/import multiple files without using loop! Choose Files in folder option and specify folder if can be applied in your use case
Then seems you need some filtering to do - Row Filter, Column Filter for start maybe…
Br,
Ivan
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.