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.
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.
One Row to many + column appender
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.