Icon

Joiner Demo

Joiner (Labs) Demo

Demonstrates the split output feature of the joiner, the merge join columns feature, and improved performance when disabling sorted outputs.

The "merge join columns" option canbe used to eliminate columns thatcontain the same value as per joincondition. The " output unmatched rows toseparate ports" option can be usedto output and inspect matches andunmatched rows separately. The "arbitrary output order" option in the Performance settings speeds upjoins as the results do not have to be sorted. However, the joiner may producea different output order every time, depending on how much main memory isavailable during execution. DepartmentsManagers2000 rows with 500 join partners each MatchesUnmatched DepartmentsUnmatched ManagersJoins are faster when selectingunsorted output order in the performance tab.Full outer join withoutmerge join columns (4 columns)Full outer join withmerge join columns (3 columns)Output unmatched rowsto separate ports Table Creator Table Creator Data Generator Table View Table View Table View Joiner (Labs) Joiner (Labs) Joiner (Labs) Joiner (Labs) The "merge join columns" option canbe used to eliminate columns thatcontain the same value as per joincondition. The " output unmatched rows toseparate ports" option can be usedto output and inspect matches andunmatched rows separately. The "arbitrary output order" option in the Performance settings speeds upjoins as the results do not have to be sorted. However, the joiner may producea different output order every time, depending on how much main memory isavailable during execution. DepartmentsManagers2000 rows with 500 join partners each MatchesUnmatched DepartmentsUnmatched ManagersJoins are faster when selectingunsorted output order in the performance tab.Full outer join withoutmerge join columns (4 columns)Full outer join withmerge join columns (3 columns)Output unmatched rowsto separate ports Table Creator Table Creator Data Generator Table View Table View Table View Joiner (Labs) Joiner (Labs) Joiner (Labs) Joiner (Labs)

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: carlwitt
Created at: 2020-07-01
On NodePit since: 2022-02-18
Last update: 2024-04-26
Created with KNIME version: v4.2.0
Tags: join

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

Try NodePit Runner!