Good morning people, everything fine ?

I have 1 database, made up of origin, destination and type.

For each origin and destination I need to add a column with some information and for it to be repeated as in the image below highlighted in yellow.

I have a flow but I would like to check if there is another opportunity.


There are different ways you can do that. One would be to use a Chunk Loop Start with a chunk size equal to the number of rows that should be repeated, then inside the loop you use a Column Appender to add your extra column. Then you add a Loop End to collect everything.
Kind regards,


If your database is extremely large for a loop solution (or you dislike loops in general), then you should be able to use the rank node to generate a grouped row count then reference those numbers to fill the values in via an if expression or the Value Lookup node.

1 Like

One Row to many + column appender

1 Like

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