How to cut a long excel file into sheets at specific rows?

Hello,

i have a long excel file from SAP which contains 7 sheets as one long file/table. I want now transform them into separate sheets.

Every new sheet in the file starts with the same word, is there a way to tell KNIME to “cut” the file always at this specific row which contains that word? So that KNIME will cut the file 6 times and i have 7 separate sheets?

Thanks in advance.

Kind regards
Stephan

You can use XLS Control Table Generator to see the Exact Cell, Column, Row of each individual values in your whole data table and then you can use row filter to filter out the word that you need so you can get all the row coordinates that contain that specific word

1 Like

Yes, create a helper column to identify the grouping and then do a group loop to create separate excel sheets per group
br

1 Like