How to split a single file in multiple file with chunk loop start.

Hello,

i’m tring to find some solutions to this easy problem, but i didn’t find a way out.

I will have huge file with more than 500.000 records. I want to split in multiple file of 80.000 rows.

I used Chunk Loop Start. But i’m having problemi with the definition of file_names based on “CurrentIteration”.

This is the WF:

Chunk is setted oon 80.000 rows.

I choose in “Create File/Folder Variables” this options to have the name of the file with the number of the iteration:

From the configuration, this is what i’m expecting from this node:

8 iterations, with each file named with the n° of the iteration.

Configuration of “Excel Writer” is this:

Using as a path the variable chosen before.

But in this way i’m able to have only one iteration:

Obviusly i’m wrong, but in which part of the process?

Many thanks to every people who can help me, i tried to find something on YT or in the forum, but i didn’t find anything with this specific settings.

Thanks,

Alberto