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!
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
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.