Problem :(

i have a problem, and i don’t know how to solve it.

This is my source file(.xlsx).

And i must have the result in this form:

The source data is random, every raport have different lenght, different “Product ID”, so i need to read everything from this file, i can’t create dictionary. I have manage to pull rows ID where new product starts:

From here i don’t know what to do. Becouse now i need to read everything from Row2 to Row12 , next from Row12 to Row22 e.t.c. I tried to use “Chunk Loop Start” and “Rows per chunk” set to 2, but that way i have rows 1-2, 3-4, 5-6, and i need 1-2, 2-3, 3-4.
Someone have any idea how to do this ?

Hi @k0sa,

i would suppose to identify for each section start row and end row. But i personally wouldn’t use rowid as identifier. I would prefer rowindex (using math formula) to get numbers, which you can then use in a filter node.

If you could upload an example file (.xls) it would be easier to come up with a suggestion.


I found solution. I used “Windows Loop Start” node, i set “window size” to 2 and “step size” to 1. Connected output data to “Rule-based Row filter” and from here was easy :slight_smile:
So topic can be closed.


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.