Hello I need help with my workflow, I have attached a picture in which it is shown. My problem is the following: I want to go through the table that is boxed in blue row by row, so that one row is always taken from the table.
Then this one row is to be merged with the table that is boxed in black.
Then the red part is to be run through.
The result is then a new row that is to be saved.
The whole process is to be repeated until all rows of the blue table have been run through.
@Lukas_Heldmann1 for me the best start for a loop is often the Table Row to Variable Loop Start which will iterate thru the table and you can convert the values (the ones you want) into Flow Variables and then steer you actions (filters etc.) with that.
Maybe you check out this article and a few examples and I think you can then put this together.
The “Concatenate” node will certainly perform a kind of merge (a new table consisting of the one row from the Chunk loop on top of the rows from the node in black), but is that the “merge” you actually want?
For example, are you looking to append the column(s) from the Blue table row onto the rows from the Black table? In that case, replacing your Concatenate with a Cross Join instead of Concatenate may be more suitable.
Or did you have some other kind of “merge” in mind?
What @MartinDDDD has suggested might be exactly what you need, but if not, perhaps you could provide a sample row of data from the Blue table, and some representative rows from the Black table (with any sensitive/private data replaced), plus the resultant required output from the initial merge (before you head into the “Red nodes”) to help make your requirement clearer.
Fair point - I am assuming that the concatenation actually results in something that works - so likely that columns of blue / black tables are matching…
