Icon

kn_​forum_​38282_​join_​tables

Join a table and check for duplicates (forum: 38282)

Join a table and check for duplicates (forum: 38282)

combine prod. data pass/fail results with cal. results Join a table and check for duplicates (forum: 38282)https://forum.knime.com/t/adding-data-from-table-b-to-table-a/38282/6?u=mlauber71 0 Either all results or the result of the inner join (if the unmatched rows are output in separate ports)1 Unmatched rows from the left input table (top input port). Inactive if "Output unmatched rows to separate ports" is deactivated.2 Unmatched rows from the right input table (bottom input port). Inactive if "Output unmatched rows to separate ports" is deactivated. Air Tstr Cal/data/full_cal_data.csvNode 4lbf vs mmpsi vs lbfmm 80~96 tests Oct-Novpsi vs mmAir Tstr Prod/data/full_prod_data.csvtests Aug-Sepmm 80~96Node 21RIGHTNode 25LEFTSerial IDsolenoid IDsolenoid ID$duplicate-type-classifier$ = "duplicate" => FALSETRUE => TRUE4905 uniqueRIGHT$duplicate-type-classifier$ = "duplicate" => FALSETRUE => TRUE545 uniqueLEFTRIGHTLEFTCSV Reader Column Filter Scatter Plot Scatter Plot Row Filter Row Filter Scatter Plot CSV Reader Row Filter Row Filter Column Filter Color Manager Column Filter Joiner Column Filter DuplicateRow Filter DuplicateRow Filter DuplicateRow Filter Rule-basedRow Filter Rule-basedRow Filter Column Filter Column Filter Joiner combine prod. data pass/fail results with cal. results Join a table and check for duplicates (forum: 38282)https://forum.knime.com/t/adding-data-from-table-b-to-table-a/38282/6?u=mlauber71 0 Either all results or the result of the inner join (if the unmatched rows are output in separate ports)1 Unmatched rows from the left input table (top input port). Inactive if "Output unmatched rows to separate ports" is deactivated.2 Unmatched rows from the right input table (bottom input port). Inactive if "Output unmatched rows to separate ports" is deactivated. Air Tstr Cal/data/full_cal_data.csvNode 4lbf vs mmpsi vs lbfmm 80~96tests Oct-Novpsi vs mmAir Tstr Prod/data/full_prod_data.csvtests Aug-Sepmm 80~96Node 21RIGHTNode 25LEFTSerial IDsolenoid IDsolenoid ID$duplicate-type-classifier$ = "duplicate" => FALSETRUE => TRUE4905 uniqueRIGHT$duplicate-type-classifier$ = "duplicate" => FALSETRUE => TRUE545 uniqueLEFTRIGHTLEFTCSV Reader Column Filter Scatter Plot Scatter Plot Row Filter Row Filter Scatter Plot CSV Reader Row Filter Row Filter Column Filter Color Manager Column Filter Joiner Column Filter DuplicateRow Filter DuplicateRow Filter DuplicateRow Filter Rule-basedRow Filter Rule-basedRow Filter Column Filter Column Filter 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: ronde
Created at: 2018-07-17
On NodePit since: 2021-12-21
Last update: 2024-04-27
Created with KNIME version: v4.5.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!