How to Join Multiple Tables with Different Schemas in KNIME (Similar to Alteryx Multi-Join)?

Hi KNIME Community,

I have a use case where I need to join multiple incoming tables from flat files, and these tables have different schemas.

In Alteryx, there is a direct tool called Join Multiple, which allows joining multiple inputs easily.

However, in KNIME, I couldn’t find a single node that does this.

So far, I’ve tried using two Joiner nodes to combine the tables, but this approach doesn’t scale well when the number of tables increases.

I came across this Multiple join - #3 by aworker suggests using Recursive Loop Start/End nodes to wrap the Joiner node and perform multiple joins iteratively. However, I couldn’t get this to work in my case.

Here’s what I need help with:

*

How can I configure the Recursive Loop so that the Joiner node joins all tables one by one?

*

Is there a better approach for joining multiple tables with different schemas in KNIME?

Any guidance, examples, or best practices would be greatly appreciated!

What I’ve Tried:

*

Used multiple Joiner nodes manually (works but not scalable).

*

Attempted Recursive Loop setup (Joiner inside loop), but I’m stuck because the Joiner node only accepts two inputs.

Goal:

A solution similar to Alteryx’s Join Multiple tool, but in KNIME.