My data is being imported to knime via an excel reader and the issue I am experiencing is with transforming the imported data into a knime friendly format with one row as headers and data following. The current format has labels and column headers from rows 0-4 then data following. At about row 22 the same labels and column headers are once again listed (for a different client this time) and this takes up another four rows with new data following. The excel sheet is basically stacked tables, each with their own headers. How can I transform this so that the workflow can recognize when one of these 4 row dividers has been reached, take necessary actions in formatting, then repeat the process? The lengths of the data will vary so I cannot hardcode certain row numbers to be removed; however, the columns will always be the same from table to table. Thanks

Excel data imported to KNIME that consists of stacked tables with multiple headers throughout

mlauber71 March 28, 2024, 10:23pm 2

@cameron767 welcome to the knime forum. You can take a look at this example, you identify the start of your tables and mark them as blocks and then import them in a loop