Table Difference Finder

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

Compare entire tables

If this option is checked all columns from the first as well as the second input will be compared against each other. Otherwise, the tables will solely be compared respective the selected columns of the reference, i.e., the second input table.
Note: Row IDs are not being compared.

Select columns from reference table

The list contains the names of those columns in the reference table to be included for the comparison. It allows you to select the columns manually (by moving them to the right panel), via wildcard/regex (all columns whose names match the wildcard/regex are included) or via type selection (all columns with a certain type are included). In case of manual selection, the behavior for new columns (i.e. that are not available at the time you configure the node)can be specified as either Enforce exclusion (new columns are excluded and therefore not used for comparison) or Enforce inclusion (new columns are included and therefore used for comparison).

Fail option:

Never: The The node will not fail on any differences between the two tables.

Differing table specs: The node will fail if any of the selected columns does not exist in the other table, or the columns differ in type or domain. Note that differing column positions are being ignored.

Differing values: On the first occurrence of differences in the values the node will fail.

Input Ports

Table to check for compliance.

Reference table.

Output Ports

Table exhibiting all differing entries.

Table containing a row for each unique column.

Best Friends (Incoming)

• Sorter (9 %) 
• Column Rename (7 %) Streamable
• Excel Reader (XLS) (7 %) StreamableDeprecated
• Row Filter (7 %) Streamable
• GroupBy (7 %) 
• Show all 48 recommendations

Best Friends (Outgoing)

• Row Filter (19 %) Streamable
• Excel Writer (XLS) (15 %) Deprecated
• Column Rename (10 %) Streamable
• Group Loop Start (9 %) 
• Math Formula (9 %) Streamable
• Show all 16 recommendations

Workflows

• 01_​Data_​Lineage_​via_​KNIME_​WebPortal (KNIME Hub) 
• 02_​HDFS_​and_​File_​Handling_​Example (KNIME Hub) 
• 05_​TableDifference_​Finder (KNIME Hub) 
• 2020_​09_​17_​Removing_​Special_​Words_​from_​Multiple_​Columns (KNIME Hub) 
• Data Lineage View (KNIME Hub) 
• Show all 7 workflows

Installation

To use this node in KNIME, install KNIME Base nodes from the following update site:

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

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.