Table Difference Checker
Test-Node extension for KNIME Workbench version 3.7.0.v201811021340 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
Best Friends (Incoming)
Database Reader (15 %) Source
Column Filter (7 %) ManipulatorStreamable
Column Rename (5 %) ManipulatorStreamable
Table Creator (4 %) Source
String Manipulation (4 %) ManipulatorStreamable
Missing Value (3 %) Manipulator
Spark to Table (3 %) 
Java Snippet (simple) (3 %) Manipulator
GET Request (3 %) ManipulatorStreamable
Variable to Table Row (3 %) Other
Row Filter (3 %) ManipulatorStreamable
RowID (3 %) ManipulatorStreamable
Sorter (3 %) Manipulator
Data Generator (3 %) SourceStreamable
Table Editor (JavaScript) (3 %) Visualizer
R Snippet (3 %) Manipulator
RDKit Descriptor Calculation (3 %) ManipulatorStreamable
R Snippet (2 %) Manipulator
Table Reader (2 %) SourceStreamable
Missing Value Column Filter (2 %) Manipulator
Column Splitter (2 %) ManipulatorStreamable- SQL Script Generator (< 1 %)
- Spark to Table (< 1 %)
SD-to-Smiles (< 1 %) Source
String to URI (< 1 %) Manipulator
Variable to Table Column (< 1 %) OtherStreamable
Table Column to Variable (< 1 %) Other
CSV Reader (< 1 %) Source
Database Connection Table Reader (< 1 %) Source- Java Snippet (< 1 %) ManipulatorStreamable
Loop End (< 1 %) LoopEnd
Concatenate (< 1 %) ManipulatorStreamable
Column Auto Type Cast (< 1 %) Manipulator
Number To String (< 1 %) Manipulator
Extract Column Header (< 1 %) Manipulator
Insert Column Header (< 1 %) Manipulator
Column Resorter (< 1 %) ManipulatorStreamable
Domain Calculator (< 1 %) Manipulator
GroupBy (< 1 %) Manipulator
Missing Value (Apply) (< 1 %) Manipulator
Rule Engine (< 1 %) PredictorStreamable
SDF Reader (< 1 %) Source
Distance Matrix Calculate (< 1 %) Manipulator
Math Formula (Multi Column) (< 1 %) ManipulatorStreamable
XLS Reader(< 1 %) SourceDeprecated
Python Script (1⇒1)(< 1 %) ManipulatorDeprecated
R Source (Table) (< 1 %) Source
String To XML (< 1 %) Manipulator
XPath (< 1 %) ManipulatorStreamable- Transformation Applier (< 1 %)
Extract InnerHTML (< 1 %) Manipulator- Smiles Reader (< 1 %) Source
MarvinSketch (< 1 %) Source
CMUSphinx4 SR (< 1 %) PredictorStreamable
Split Collection Column (< 1 %) Manipulator
Strings to Binary Objects (< 1 %) Manipulator- Concatenate (Optional in) (< 1 %) ManipulatorStreamable
Auto-Binner (< 1 %) Manipulator
Constant Value Column (< 1 %) ManipulatorStreamable
Cross Joiner (< 1 %) ManipulatorStreamable
Nominal Value Row Filter (< 1 %) ManipulatorStreamable
Row Splitter (< 1 %) ManipulatorStreamable
Reference Row Filter (< 1 %) Manipulator
Joiner (< 1 %) Manipulator
Pivoting (< 1 %) Manipulator
String Replacer (< 1 %) ManipulatorStreamable
Unpivoting (< 1 %) Manipulator
Rule-based Row Filter (< 1 %) ManipulatorStreamable- Rule Engine (Dictionary) (< 1 %) PredictorStreamable
Empty Table Creator (< 1 %) Source
PMML Predictor(< 1 %) PredictorDeprecated
Math Formula (< 1 %) ManipulatorStreamable
Document Data Extractor(< 1 %) ManipulatorDeprecated
Term To String (< 1 %) Manipulator
ROC Curve (JavaScript) (< 1 %) Visualizer
Table Difference Checker (< 1 %) Other
Date Field Extractor (legacy) (< 1 %) Manipulator
Mask Date/Time (legacy) (< 1 %) Manipulator
Remove Empty Rows (< 1 %) ManipulatorStreamable- Standardize (< 1 %)
HttpRetriever (< 1 %) Manipulator- Show all 81 recommendations
Best Friends (Outgoing)
- Java Snippet (73 %) ManipulatorStreamable
Database SQL Executor (9 %) Manipulator
Merge Variables (9 %) Other
Quit WebDriver (9 %) Sink- Table Difference Checker (< 1 %) Other
Workflows
02_HDFS_and_File_Handling_Example- 017002_HDFS_File_Handling
- HDFS File Handling
- 01_Validating_KNIME_Workflows
Installation
To use this node in KNIME, install Test-Node extension for KNIME Workbench from the following update site: