How to concatenate All the excel files and sheets existing in a folder

Hi !

I Need to concatenate in only one file, all the files “xlsx” in a folder, and also, all the sheets inside them. Could someone ever did this? I know in alteryx its possible, but, I can replicate the flux on Knime.

All the Excel Files has different names, but all the sheets inside than has the same structure and headers.

The result should be a single File with all the sheets concatenated

I’ve been trying to use the List Files + Table Row To Variable Loop Start, however, zero success.

Hope someone have an idea how to solve this.

Thanks

Hi @hdelfis-crf -

Welcome to the forum. Check out this workflow on the KNIME Hub - I think it may have what you’re looking for.

3 Likes

Scott ! Thank you so much! It worked perfectly!

:metal:

2 Likes

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