Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Table Difference Finder
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:

  1. Go to item

Related workflows & nodes

  1. Go to item
    QA
    metan > Public > QA
  2. Go to item
    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. Go to item
    compare_row_pairs
    lukass > Forum > compare_row_pairs
  4. Go to item
    09_Compare csv_Table Difference Finder_Upload
    totaldataloss > Public > TableDiffUploadForum > 09_Compare csv_Table Difference Finder_Upload
  5. Go to item
    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. Go to item
    TermVectorBug
    iris > Public > testing > TermVectorBug
  7. Go to item
    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. Go to item
    Disecting Java Snippet
    stelfrich > Public > Disecting Java Snippet
  9. Go to item
    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. Go to item
    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

No known nodes available

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits