Aggregate excel files without filters

Good morning, for a new project every day I have to aggregate and manipulate 76 excel files that some colleagues upload in a specific folder the previous evening. Unfortunately, however, colleagues save the excel files with some filters inserted. I would like to know how I can set up a function in knime that allows me to aggregate excel files ignoring any filters.

Hello @fmicera,

and welcome to KNIME Community!¨

There is option Skip hidden rows under Advanced Settings tab of Excel Reader node. This option is enabled by default. Disable it and you should get filtered data into KNIME as well.

Br,
Ivan

4 Likes

Thanks Ivan, Now it works fine

2 Likes

Glad to hear that @fmicera :slight_smile:
Ivan

1 Like

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