Extract certain rows and columns from multiple excel files

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

2 Likes

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 :wink:

Then seems you need some filtering to do - Row Filter, Column Filter for start maybe…

Br,
Ivan

1 Like

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