0 ×

Table Difference Checker

Test-Node extension for KNIME Workbench version 4.1.0.v201909231846 by KNIME AG, Zurich, Switzerland

Used in regression tests to test the created data table with a reference data table. The node will compare (depending on the dialog settings) the incoming tables during execute and fails with an exception if the tables are not equal (or do not meet the expectations). In that case the node stays not executed and the test will fail.

In the node's dialog, you can adjust how individual columns are compared. The default is to check for exact equality. For certain column types you can relax the comparison by using special checkers. Examples are numeric column where you may want to use an epsilon or string columns where you may want to ignore different line feed characters (Windows vs. Unix). The special checkers are used for the cell contents as well as for the column domain (i.e. possible values and bounds).
In case a column is a collection, you can select a checker for the elements' type which is then applied to every element in the collection (except the Equality checker which does look into the collection).

In order to configure column, change the checker in the second column and if applicable configure it in the panel below the column table.

Options

Ignore row IDs: Select this option if you want to ignore the row IDs of the two tables. Use this option only if you know what you are doing. Row IDs are an integral part of any data table and they should not change during the lifetime of a node because this may break existing workflows.

Input Ports

: Table with the output of the node to test
: The reference table.

Best Friends (Incoming)

Database Reader (legacy) (7 %)
Column Filter (6 %) Streamable
Sorter (5 %)
Column Rename (4 %) Streamable
Table Creator (3 %)
RowID (3 %) Streamable
Domain Calculator (3 %)
Row Filter (3 %) Streamable
~~Excel Reader (XLS)~~ (3 %) StreamableDeprecated
Column Auto Type Cast (2 %)
~~Variable to Table Row~~ (2 %) Deprecated
Table Reader (2 %) Streamable
~~Number To String~~ (2 %) Deprecated
GroupBy (2 %)
String Manipulation (2 %) Streamable
Java Snippet (simple) (2 %)
Insert Column Header (1 %)
Column Splitter (1 %) Streamable
DB Reader (1 %) Streamable
R Snippet (1 %)
Disturber Node (1 %)
CSV Reader (< 1 %)
Java Snippet (< 1 %) Streamable
Concatenate (< 1 %) Streamable
Column Resorter (< 1 %) Streamable
Missing Value Column Filter (< 1 %)
Joiner (< 1 %)
Missing Value (< 1 %)
Reference Column Resorter (< 1 %) Streamable
String Replacer (< 1 %) Streamable
Data Generator (< 1 %) Streamable
ORC Reader (< 1 %) Streamable
Spark to Table (< 1 %) Streamable
Bag Of Words Creator (< 1 %)
Table Editor (< 1 %)
GET Request (< 1 %) Streamable
Test Data Generator (< 1 %)
XPath (< 1 %) Streamable
RDKit Descriptor Calculation (< 1 %) Streamable
SQL Script Generator (< 1 %)
Spark to Table (< 1 %)
SD-to-Smiles (< 1 %)
Smiles Reader (< 1 %)
R Snippet (< 1 %)
MarvinSketch (< 1 %)
CMUSphinx4 SR (< 1 %) Streamable
Create Collection Column (< 1 %) Streamable
Split Collection Column (< 1 %)
Strings to Binary Objects (< 1 %)
String to URI (< 1 %)
Try (Data Ports) (< 1 %)
~~Variable to Table Column~~ (< 1 %) StreamableDeprecated
~~Table Column to Variable~~ (< 1 %) Deprecated
Database Connection Table Reader (legacy) (< 1 %)
Parameterized Database Query (legacy) (< 1 %)
File Reader (< 1 %) Streamable
Loop End (2 ports) (< 1 %)
Loop End (< 1 %)
~~Concatenate (Optional in)~~ (< 1 %) StreamableDeprecated
Auto-Binner (< 1 %)
~~String To Number~~ (< 1 %) StreamableDeprecated
Extract Column Header (< 1 %)
Constant Value Column (< 1 %) Streamable
Cross Joiner (< 1 %) Streamable
Reference Column Filter (< 1 %) Streamable
Nominal Value Row Filter (< 1 %) Streamable
Row Splitter (< 1 %) Streamable
Reference Row Filter (< 1 %)
Pivoting (< 1 %)
Missing Value (Apply) (< 1 %)
Transpose (< 1 %)
Ungroup (< 1 %) Streamable
Unpivoting (< 1 %)
Rule-based Row Filter (< 1 %) Streamable
Rule Engine (< 1 %) Streamable
Rule Engine (Dictionary) (< 1 %) Streamable
CASE Switch Data (End) (< 1 %)
Cache (< 1 %)
Extract Table Spec (< 1 %)
Parquet Reader (< 1 %) Streamable
SDF Reader (< 1 %)
Empty Table Creator (< 1 %)
Distance Matrix Calculate (< 1 %)
H2O to Table (< 1 %)
Math Formula (< 1 %) Streamable
Math Formula (Multi Column) (< 1 %) Streamable
~~XLS Reader~~ (< 1 %) Deprecated
~~Document Data Extractor~~ (< 1 %) Deprecated
Term To String (< 1 %)
ROC Curve (< 1 %)
Container Output (Table) (< 1 %)
JSON to Table (< 1 %)
Node Adjacency Matrix (< 1 %)
~~Python Script (1⇒1)~~ (< 1 %) Deprecated
Python Script (1⇒1) (< 1 %)
Python Script (2⇒1) (< 1 %)
R Source (Table) (< 1 %)
Table Difference Checker (< 1 %)
UNIX Timestamp to Date&Time (< 1 %) Streamable
Date Field Extractor (legacy) (< 1 %)
Mask Date/Time (legacy) (< 1 %)
String To XML (< 1 %)
Remove Empty Rows (< 1 %) Streamable
Transformation Applier (< 1 %)
Standardize (< 1 %)
HTTP Retriever (< 1 %)
Extract InnerHTML (< 1 %)
Show all 107 recommendations

Workflows

Installation

To use this node in KNIME, install KNIME Testing Framework from the following update site:

KNIME 4.1

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.

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.