The Table Difference Finder offers the functionality to compare two tables by means of their values and table specs. Firstly, the values in the selected columns are compared in both tables, and the possible differences are shown for each row and column. Secondly, the types, domains, and positions of the selected columns are compared in both tables, and the results are shown for each column. The selected columns are either all columns in both tables, or a subset of columns in the reference table, i.e. the second input.
Options
Popular Successors
- Joiner6 %
- Excel Writer6 %
Row Filter (deprecated)4 %- String Manipulation4 %
- Timer Info4 %
- Rule-based Row Filter3 %
- GroupBy3 %
- Table Difference Finder2 %
- Reference Row Filter2 %
Joiner2 %- Empty Table Switch2 %
Cell Replacer2 %- Math Formula2 %
- Column Comparator2 %
- Column Filter2 %
- Cell Splitter1 %
- Nominal Value Row Filter1 %
Row Splitter (deprecated)1 %- Group Loop Start1 %
- Loop End1 %
- String to Number1 %
Column Rename1 %- Sorter1 %
- Table Editor (JavaScript)1 %
- Add Empty Rows1 %
- Column Resorter1 %
- Reference Row Splitter1 %
- RowID< 1 %
- Interactive Table (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Concatenate< 1 %
- Case Converter< 1 %
- Column Appender< 1 %
- Rule Engine (Dictionary)< 1 %
- Extract Table Spec< 1 %
- Math Formula (Multi Column)< 1 %
- Try (Data Ports)< 1 %
- Active Branch Inverter< 1 %
- CSV Writer< 1 %
- Java Snippet< 1 %
- Table Validator (Reference)< 1 %
- Table Manipulator< 1 %
- Pivot< 1 %
- Column Splitter< 1 %
- Table Transposer< 1 %
- Rule Engine< 1 %
- DB Writer< 1 %
- Catch Errors (Data Ports)< 1 %
- Table Row to Variable< 1 %
- Table Writer< 1 %
Loop End (2 ports)< 1 %Loop End< 1 %- Perl Scripting< 1 %
- Column Combiner< 1 %
- Column Aggregator< 1 %
- Constant Value Column< 1 %
- Table Validator< 1 %
- Duplicate Row Filter< 1 %
- Filter Apply< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Missing Value< 1 %
- String Manipulation (Multi Column)< 1 %
- String Replacer< 1 %
- Value Counter< 1 %
- Rule-based Row Splitter< 1 %
- End IF< 1 %
- IF Switch< 1 %
- Extract Table Dimension< 1 %
- Table View< 1 %
- Table to PMML Ensemble< 1 %
- Column Expressions (legacy)< 1 %
- Python Script (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- Table Difference Checker< 1 %
- Workflow Service Output< 1 %
CSV Writer< 1 %Table Writer< 1 %- Table Row to Variable Loop Start< 1 %
- DB Update< 1 %
- Variable to Table Column< 1 %
Variable Loop End< 1 %- RProp MLP Learner< 1 %
- Number to String< 1 %
- Random Matcher< 1 %
- Table to Image< 1 %
- Table Creator< 1 %
- Numeric Scorer< 1 %
- Column Auto Type Cast< 1 %
- Column Renamer (Dictionary)< 1 %
- Create Table Structure< 1 %
- Constant Value Column Filter< 1 %
- Row Filter (Labs)< 1 %
- Number Rounder< 1 %
- Row Sampling< 1 %
- Set Operator< 1 %
- Ruleset Editor< 1 %
- Statistics< 1 %
- CASE Switch Start< 1 %
- Cache< 1 %
- Save Workflow< 1 %
- SDF Writer< 1 %
- DB Insert< 1 %
- DB Merge< 1 %
Excel Writer (XLS)< 1 %- Sentence Extractor< 1 %
- Term to String< 1 %
- Scatter Plot (JavaScript)< 1 %
- Container Output (Table)< 1 %
- Table to JSON< 1 %
- Date&Time Difference< 1 %
- Fingerprints< 1 %
Views
- This node has no views
Workflows
00_Topic_Modeling_with_Verified_ComponentsKNIME Hub- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 01_Data_Lineage_via_KNIME_WebPortalKNIME Hub
- 01_Unit_testingKNIME Hub
- 01_Unit_testingKNIME Hub
- Show all 113 workflows
Links
- Comparing data from 2 different filesby armingrudd on 2020-07-21forum.knime.com/p/97508
- Joiner not workingby izaychik63 on 2021-08-14forum.knime.com/p/131856
- Multiple outputs from a join?by AnotherFraudUser on 2020-07-26forum.knime.com/p/98076
- Compare Two Tables – KNIME Community Hubby ipazin on 2023-01-02forum.knime.com/p/186889
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.