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.
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.
Thanks Ivan, Now it works fine
Glad to hear that @fmicera
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.