Multiple cascading joins

Hi everyone,
i’m struggling with an apparently easy task, but i can’t figure out how to implement this.
Suppose to have many tables, with the very same structure, a [key] column and other columns: what i want to do is creating a loop that iterate trought that files and join them using that [key] column.

I just can’t handle correctly the loop, resulting in a conflict (nesting/out of scope).
Any suggestion pls?

Luca

i’m uploading a workflow just for testing purpose
cascading joins.knwf (184.2 KB)

Hi @Luca_Italy,

I would use the Recursive Loop nodes with two ports. In this way you can avoid using a nested loop.
Please find the workflow attached.

cascading joins.knwf (180.9 KB)

Best
Kathrin

5 Likes

Whoa, thank you so much. Exactly what i wanted to achieve!

Luca

2 Likes

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