merge the first 4 rows into 1 row and so on

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!

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):

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:

Hope this helps!

6 Likes