0 ×

Table Difference Finder

KNIME Base Nodes version 4.3.3.v202105242122 by KNIME AG, Zurich, Switzerland

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

Icon
Table to check for compliance.
Icon
Reference table.

Output Ports

Icon
Table exhibiting all differing entries.
Icon
Table containing a row for each unique column.

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

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

KNIME 4.3

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.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

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.