How to separate rows automatically and insert them in several excels

[mikep2020]

Hello
I want to separate the rows by 300 to 300 and save each one in a separate excel.
The main goal is to do this automatically with a loop

Assuming that I want to separate 50 filters in the intervals of 300 to 300, how can this be done automatically?
Thank you very much

[rolandnemeth]

Hi @mikep2020,

Let’s have a look at the chunk loop start node, I hope it helps.

Chunk Loop Start

Roland

[mikep2020]

Please, if you can, put it in WORKFLOW

[rolandnemeth]

Please find an example here from @heiko

Chunk Loop Start – heiko

Roland

[rolandnemeth]

@mikep2020, please find attached a simple example.

export_excel_inchunks.knwf (27.7 KB)
input.xlsx (8.7 KB)

Modify the rows per chunk value accordingly and the location of the file export.

[mikep2020]

Thank you very much

[rolandnemeth]

You are welcome, @mikep2020!