Segmenting information in several csv files maintaning integrity

Hi everybody,

I have some input data that comes from a table creator which should be grouped by EQP_NAME (equipment name). All these equipments have different number of lines with different additional information and the # of lines can be seen as a value counter result, depicted below.

What I need is a way to persist the equipment information on csv files, without the risk of creating files that split equipment information. What I mean is each csv file should have one or more equipment information as a whole, where I can parameterize how it should behave: for instance, I can inform how many equipments I want on each file or how many lines each file should have, without the risk of information loss (for the last one it should add more lines to complete the equipment information, if that is the case).

This behaviour is quite similar to the chunk loop, except by the fact the chunk loop allows the information to be splitted, by only concerning about the # of files or lines, not looking at the type of information.

Here’s the workflow I started to draw:

Segment n groups.knwf

I appreciate if someone could give me a hand on this. Please let me know if I need to be more clear.

Thanks in advance!

Gilmar