Help me) How can I split the data into 2 Xel files. For example, I have 5 million lines, I want 1 file to be uploaded with 2 million lines, and the other with 3 million lines. How to do it?
Are you sure to work with Excel and 5 million lines?
If yes, you can just split the data with the “Partitioning” node:
Hello @DenisKhayrov
Welcome to KNIME Community Forum. Have fun here 
Please try ‘Table Splitter’ node. With such configuration
I’m able to divide input table into:
- First table containing Row0-Row2 by Row ID
- Second table containing other rows.
It might happen that you would like to apply some extra conditions. Then, please share those conditions.
Happy KNIMEing!
1 Like
for example, I have an upload to excel on 5 sheets of 1 million lines, I need Name to upload 2 books, 1 book with two sheets, another book with three sheets. Thanks for the answers above, I’ll write when I try to do it.