Icon

Joiner

Combining data sets is one of the most common and important operations during data processing. The Joiner node allows you to combine two tables according to one or more common, or key, fields.

The section Include In Output has three check boxes which allow you to create different types of joins. We encourage you to try all combinations of turning boxes off and on. Pay attention to the diagram on the right, as it indicates which type of join the selected options creates.

By default, the results of the join are output through the uppermost output port. In this default configuration, the middle and lower ports are inactive. However, by selecting the "split results" option, you can view the left, inner, and right outputs in the three output ports. This is helpful when evaluating the results of the join operation.

On the Column Selection tab there are two sets of include/exclude boxes. The upper box corresponds to the columns in the top input, the lower for the bottom input. Make sure to check the appropriate "enforce inclusion" or "enforce exclusion" options to ensure the correct columns pass through the join.

Joiner Combining data sets is one of the most common and important operations during dataprocessing. The Joiner node allows you to combine two tables according to one ormore common, or key, fields.The section Include In Output has three check boxes which allow you to createdifferent types of joins. We encourage you to try all combinations of turning boxes offand on. Pay attention to the diagram on the right, as it indicates which type of join theselected options creates.By default, the results of the join are output through the uppermost output port. In thisdefault configuration, the middle and lower ports are inactive. However, by selectingthe "split results" option, you can view the left, inner, and right outputs in the threeoutput ports. This is helpful when evaluating the results of the join operation.On the Column Selection tab there are two sets of include/exclude boxes. The upperbox corresponds to the columns in the top input, the lower for the bottom input. Makesure to check the appropriate "enforce inclusion" or "enforce exclusion" options toensure the correct columns pass through the join. In this inner join, we joined on the Country field fromeach table. Deselect the Country field from the righttable.Because 'USA' is not in the second table, only thematching 'Canada' records are in the output. Night Heron Data, 2023 This join represents a left outer join -- all records fromthe left (top) table are returned regardless if theymatch with any records from the right (lower) table.In the output, you can see the Population (right)figures for 'USA' are all missing because that valuedoes not exist in the right table. This example shows a full outer join--all records fromboth join tables are present. The results were splitinto the component inner, left, and right outputs forease of understanding which records below to whichpart of the join. Notice how the inner (top port) shows only 'Canada'records, the middle port shows only 'USA' records,and the bottom port shows all other records from theright table. Input some dataInner joinCountry-leveldataLeft outer join, no splitFull outer join,split results Table Creator Joiner Table Creator Joiner Joiner Joiner Combining data sets is one of the most common and important operations during dataprocessing. The Joiner node allows you to combine two tables according to one ormore common, or key, fields.The section Include In Output has three check boxes which allow you to createdifferent types of joins. We encourage you to try all combinations of turning boxes offand on. Pay attention to the diagram on the right, as it indicates which type of join theselected options creates.By default, the results of the join are output through the uppermost output port. In thisdefault configuration, the middle and lower ports are inactive. However, by selectingthe "split results" option, you can view the left, inner, and right outputs in the threeoutput ports. This is helpful when evaluating the results of the join operation.On the Column Selection tab there are two sets of include/exclude boxes. The upperbox corresponds to the columns in the top input, the lower for the bottom input. Makesure to check the appropriate "enforce inclusion" or "enforce exclusion" options toensure the correct columns pass through the join. In this inner join, we joined on the Country field fromeach table. Deselect the Country field from the righttable.Because 'USA' is not in the second table, only thematching 'Canada' records are in the output. Night Heron Data, 2023 This join represents a left outer join -- all records fromthe left (top) table are returned regardless if theymatch with any records from the right (lower) table.In the output, you can see the Population (right)figures for 'USA' are all missing because that valuedoes not exist in the right table. This example shows a full outer join--all records fromboth join tables are present. The results were splitinto the component inner, left, and right outputs forease of understanding which records below to whichpart of the join. Notice how the inner (top port) shows only 'Canada'records, the middle port shows only 'USA' records,and the bottom port shows all other records from theright table. Input some dataInner joinCountry-leveldataLeft outer join, no splitFull outer join,split results Table Creator Joiner Table Creator Joiner Joiner

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: johnemery
Created at: 2023-05-29
On NodePit since: 2023-05-30
Last update: 2024-05-02
Created with KNIME version: v4.7.2
Tags: joinerjoincombinenode bitesnight heron data

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

Try NodePit Runner!