Icon

2019_​10_​03_​Comparing_​Two_​Tables_​new

Compare Two Tables

This workflow compares 2 tables with same structure meaning they have same number of columns and matching columns have same names and types. Comparison is done in a loop using Column Comparator node. In each loop iteration two columns are compared and and additional column with values TRUE or FALSE is created.

Compare two TablesThis workflow compares 2 tables with same structure meaning they have same number of columns and matchingcolumns have same names and types. Comparison is done in a loop using Column Comparator node. In each loopiteration two columns are compared and and additional column with values TRUE or FALSE is created.Forum link: https://forum.knime.com/t/data-set-comparison/18507https://forum.knime.com/t/compare-content-of-multiple-columns-in-pairs-of-two/15950 Table ATable BCompare columnJoin all column that need comparisonGet column namesStart loop for each pair of columnsTranspose to get names in one columnFilter so it only leaves two columnsCreate wild card for filteringAppend columnsCreate flow variable for second column nameNode 47Node 48Node 49 Table Creator Table Creator Column Comparator Joiner ExtractColumn Header Table Row ToVariable Loop Start Transpose Column Filter String Manipulation(Variable) Loop End (ColumnAppend) String Manipulation(Variable) Variable toTable Row Create CollectionColumn Table Rowto Variable Compare two TablesThis workflow compares 2 tables with same structure meaning they have same number of columns and matchingcolumns have same names and types. Comparison is done in a loop using Column Comparator node. In each loopiteration two columns are compared and and additional column with values TRUE or FALSE is created.Forum link: https://forum.knime.com/t/data-set-comparison/18507https://forum.knime.com/t/compare-content-of-multiple-columns-in-pairs-of-two/15950 Table ATable BCompare columnJoin all column that need comparisonGet column namesStart loop for each pair of columnsTranspose to get names in one columnFilter so it only leaves two columnsCreate wild card for filteringAppend columnsCreate flow variable for second column nameNode 47Node 48Node 49 Table Creator Table Creator Column Comparator Joiner ExtractColumn Header Table Row ToVariable Loop Start Transpose Column Filter String Manipulation(Variable) Loop End (ColumnAppend) String Manipulation(Variable) Variable toTable Row Create CollectionColumn Table Rowto 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: Johnny
Created at: 2019-01-03
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.1.2
Tags: Data ManipulationComparisonTable Validation

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

Try NodePit Runner!