How to read multiple sheets with "sheet name" on

Dear all,
I’d like to read multiple sheets in multiple files with “sheet names” also shown on the columns. I tried to below loop and nodes to complete but it could only show “file names” instead of “sheet names”. Appreciate if anyone can help with this problem! :slight_smile:

Example of the input/ expected output files are attached.

More details-
My files are like
File #1- 2018 data in one file with 12 sheets going from Jan to Dec.
File #2- 2019 data in one file with 12 sheets going from Jan to Dec
Expected output.xlsx (10.8 KB)
2018.xlsx (13.4 KB)
2019.xlsx (13.4 KB)

Hi there @cynn2981,

welcome to KNIME Community!

You can use Constant Value Column node after Excel Reader to add that information. Use flow variable created from second Table Row to Variable Loop Start node which is containing sheet name.

This way I think you do not need bottom branch and Cross Joiner :wink:

Happy KNIMEing!

Br,
Ivan

4 Likes

Hello Ivan,
It worked!! Thank you so much! :slight_smile: :slight_smile:

2 Likes

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