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?
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