Icon

Joiner Example

There has been no title set for this workflow's metadata.

There has been no description set for this workflow's metadata.

Combining Data SetsJoiner Input some data Input some data Input some data Input some data Inner join using ProductID as a join field Join resulting in duplicaterecords Calculations are now incorrectdue to poorly built join Use GroupBy to eliminateduplicate values in original table Join not resulting inunwanted duplicates Calculations yield correctresults due to properlybuilt join Left outer join on SiteID Aggregate values Inventory DetailsInventory MasterInventory FactInventory SitesNode 6Join resulting induplicate valuesNode 8Join withoutunwanted duplicatesNode 10Node 11Node 12Node 13 CSV Reader CSV Reader CSV Reader CSV Reader Joiner Joiner GroupBy Joiner GroupBy GroupBy Joiner GroupBy Combining Data SetsJoiner Input some data Input some data Input some data Input some data Inner join using ProductID as a join field Join resulting in duplicaterecords Calculations are now incorrectdue to poorly built join Use GroupBy to eliminateduplicate values in original table Join not resulting inunwanted duplicates Calculations yield correctresults due to properlybuilt join Left outer join on SiteID Aggregate values Inventory DetailsInventory MasterInventory FactInventory SitesNode 6Join resulting induplicate valuesNode 8Join withoutunwanted duplicatesNode 10Node 11Node 12Node 13 CSV Reader CSV Reader CSV Reader CSV Reader Joiner Joiner GroupBy Joiner GroupBy GroupBy Joiner GroupBy

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: John Emery
Created at: 2022-02-16
On NodePit since: 2023-08-16
Last update: 2024-05-03
Created with KNIME version: v5.1.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!