merge the first 4 rows into 1 row and so on

[Saishiyam]

Hi there,
My data looks somewhat like this:

How do I merge the first 4 rows into a single row and so one. I have added a special character ‘;’ every 4th row thinking this might help. Any help would be appreciated.
Thank you!

[qqilihq]

Hi Saishiyam,

I would address this using the “Chunk” loop (the ; is not necessary in this case, at it will always process four rows in each iteration):

Chunk Loop Start

Alternatively (maybe more performant if you have long tables?!), you could use the Math Formula and GroupBy nodes. Create a formula like floor($$ROWINDEX$$ / 4) to generate a new column with indices for the groups and then group based on this column in the GroupBy node:

Math Formula

GroupBy

Hope this helps!