Hub
NodeNode / Manipulator

Table Difference Finder

Manipulation Table
Drag & drop
Like
Copy short link

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.

Node details

Input ports
  1. Type: Table
    Table to compare to
    Table to check for compliance.
  2. Type: Table
    Reference table
    Reference table.
Output ports
  1. Type: Table
    Value differences
    Table exhibiting all differing entries.
  2. Type: Table
    Domain differences
    Table containing a row for each unique column.

Extension

The Table Difference Finder node is part of this extension:

Related workflows & nodes

  1. QA
    metan > Public > QA
    metan
  2. WF1
    totaldataloss > Public > CSVReader_Not_Reading_New_Column > WF1
    totaldataloss
  3. Table Difference Finder
    ETL Data manipulation String manipulation
    +1
    This workflow shows the usage of Table Difference Finder node. A csv file is read in. The…
    knime > Examples > 02_ETL_Data_Manipulation > 04_Transformation > 05_TableDifference_Finder
    knime
  4. compare_row_pairs
    lukass > Forum > compare_row_pairs
    lukass
  5. 09_Compare csv_Table Difference Finder_Upload
    totaldataloss > Public > TableDiffUploadForum > 09_Compare csv_Table Difference Finder_Upload
    totaldataloss
  6. Removing Special Words from Multiple Columns
    Data Manipulation Data Cleaning Multi Column
    +2
    This workflow demonstrates how to remove i.e. clean multiple columns removing all words l…
    ipazin > Public > 2020_09_17_Removing_Special_Words_from_Multiple_Columns
    ipazin
  7. TermVectorBug
    iris > Public > testing > TermVectorBug
    iris
  8. Parse Contract Values Testflow
    Best practices Data engineer Data engineering
    +7
    For the company, it is important that contract values are always parsed correctly, even a…
    lada > Public > Testing Framework > testflows > JUnit > 01_Parse_Contract_Values_Testflow_JUnit
    lada
  9. Disecting Java Snippet
    stelfrich > Public > Disecting Java Snippet
    stelfrich
  10. Challenge 9 - Simple Anonymization - Solution
    Privacy Anonymization Justknimeit
    +1
    You would like to post a question on the KNIME forum, but you have confidential data that…
    knime > Just KNIME It! > Challenge 9 - Simple Anonymization - Solution
    alinebessa