Icon

251120_​MulitJoin

Define Paths to Files here
Define Columns for GroupBy and Joining here

This IF-Switching is introduced to handle the last iteration where no new file is available

Forum; How to Join Multiple Tables with Different Schemas in KNIME (Similar to Alteryx Multi-Join)? - KNIME Analytics Platform - KNIME Community Forum

Recursive Loop Start
Paths
Table Creator
Keep Last Iteration only
Recursive Loop End
Node 31
IF Switch
First Table
Excel Reader
Row Filter
End IF
Excel Reader
Extract Table Dimension
GroupCols
Table Creator
String to Path (Variable)
Table Row to Variable
GroupBy
Table Row to Variable
Joiner
Table Row to Variable
Rule Engine Variable
Joiner
Row Filter
GroupBy
Math Formula (Variable)

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: andi_KNIME
Created at: 2025-11-20
On NodePit since: 2025-11-20
Last update: 2025-11-20
Created with KNIME version: v5.8.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!