Merge all excel sheets in a file to one

[mlauber71]

@sujesh you could take a look at this workflow. It takes the data fro the line 9 of each sheet since they seem to contain the data (if not please change). You might delete lines that are unwanted:

kn_forum_51793_consolidate_multiple_excel_files_into_one.knwf (55.3 KB)

If you want to do more complicated imports of blocks of data you might have to take a look here:

Move head rows to a column

@willy_oracle typically you would mark all lines with a Counter. Then identify the ‘headers’ with a rule engine [IF Col1 LIKE “Head*” => Counter] and keep that (starting) row in a separate column. Then you fill the missings with the previous value so a block would emerge marking the data table: [image] So now you have the blocks marked an can use a Table Row to Variable Loop Start – KNIME Community Hub or Group Loop Start – KNIME Community Hub to do something with the blocks (export them delet…