Merge multiple sheets into one

KNIME Analytics Platform
1

Hi, can anybody help me

I have a file with multiple worksheets that i would like merge into a unique sheet. Is there any chance to do that ?
I already use read excel sheet names - table row to variable loop - excel reader but it always use the first sheet and not all of it.

2

@mracostag97 welcome to the KNIME forum. That is certainly possible to do. You might need two loops to first get the Names and then import the sheets from every file:

More on KNIME and Excel here:

1 Like