Error in consolidate multiple excel files

Hope all the best with you.

I just create a workflow to consolidate multiple excel to one excel. I found I can’t consolidate all the excel just only one. Seems there is wrong with excel reader setting. could you help me?

Hi @cathy and welcome to the KNIME community.

You can open multiple Excel files from the Excel Reader node without having to go through loops.

There’s an option to read multiple files from a folder (so you just need to have the files in the same folder):

And you can filter what files you want, and if you want to go into subfolders, etc.

So, you don’t need to go through loops and open 1 file at a time.


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