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
  2. 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
  3. compare_row_pairs
    lukass > Forum > compare_row_pairs
  4. 09_Compare csv_Table Difference Finder_Upload
    totaldataloss > Public > TableDiffUploadForum > 09_Compare csv_Table Difference Finder_Upload
  5. 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
  6. TermVectorBug
    iris > Public > testing > TermVectorBug
  7. 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
  8. Disecting Java Snippet
    stelfrich > Public > Disecting Java Snippet
  9. 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
  10. Days With Price Changes
    #justknimeit-4 #justknimeit
    There has been no description set for this workflow's metadata.
    tommy > Public > Just KNIME it > 2022-04 > Days With Price Changes