This node ensures a certain table structure and table content using the table structure and table content of a second table as reference. The table to validate should be connected to the first input port and the reference table to the second input port. Contrary to the Table Validator node, the performed validation checks will applied on the bases of all columns of the reference table and can't be adjusted per column. It is ensured that the result table structure is mostly identical to the reference specification. That is done by resorting of columns, the insertion of missing columns (filled with missing values) and optional removal of additional columns. You can also choose if each column is required and if the data type or the domain should be checked/converted. If the validation succeeds, data gets output to the first port (potentially renamed, sorted according to the reference specification and with converted types). If the validation fails, the first port is inactive and the second port contains a table that lists all conflicts or the node fails. All options mentioned below marked with Data forces also a traversal of the input data.
Options
General settings
Validation Settings
Output Ports
- Table with corrected and validated structure. Depending on the validation result and the Behavior if validation fails settings, this port may be inactive.
- Table where missing values have been handled. Depending on the validation result and the Behavior if validation fails settings, this port may be inactive.
Popular Successors
- Concatenate5 %
- Column Filter5 %
- Missing Value5 %
Row Filter (deprecated)4 %- Column Expressions3 %
- GroupBy3 %
- Joiner3 %
Excel Writer (XLS)3 %Database Writer1 %- Reference Column Filter1 %
- IF Switch1 %
- Excel Writer1 %
Loop End (2 ports)1 %Concatenate (Optional in)1 %- RDKit Interactive Table1 %
- Loop End1 %
- Date&Time to legacy Date&Time1 %
String To Number1 %Column Rename1 %- Java Snippet< 1 %
- Constant Value Column< 1 %
- Catch Errors (Data Ports)< 1 %
- CSV Writer< 1 %
- Table Writer< 1 %
Loop End< 1 %Cell Replacer< 1 %- Number to String< 1 %
Column Appender< 1 %- Table Validator (Reference)< 1 %
Row Splitter (deprecated)< 1 %- Reference Column Resorter< 1 %
- Rule-based Row Splitter< 1 %
- Cache< 1 %
- DB Merge< 1 %
- Counter Generation< 1 %
Table Row to Variable< 1 %- Column Merger< 1 %
- Domain Calculator< 1 %
- Missing Value Column Filter< 1 %
- Set Operator< 1 %
- Rule-based Row Filter< 1 %
- Extract Table Spec< 1 %
- String to Date&Time< 1 %
- Table Row to Variable< 1 %
- Variable Condition Loop End< 1 %
Variable Condition Loop End< 1 %- Regression Predictor< 1 %
- String to Number< 1 %
- Column Renamer< 1 %
- Column Aggregator< 1 %
- Column Appender< 1 %
- Column Name Extractor< 1 %
- Column Resorter< 1 %
- Table Validator< 1 %
- Reference Row Filter< 1 %
Joiner< 1 %- Table Manipulator< 1 %
- RowID< 1 %
- Sorter< 1 %
- Column Splitter< 1 %
- String Manipulation< 1 %
- String Manipulation (Multi Column)< 1 %
- Table Difference Finder< 1 %
- Table Transposer< 1 %
- Rule Engine< 1 %
- CASE Switch End< 1 %
- Empty Table Switch< 1 %
CASE Switch Data (End)< 1 %- End IF< 1 %
- DB Insert< 1 %
- DB Loader< 1 %
- DB Writer< 1 %
DB Table Creator< 1 %- DB Table Creator< 1 %
- Math Formula< 1 %
- Java Snippet (simple)< 1 %
- Table View (JavaScript)< 1 %
- Date&Time to String< 1 %
Table Row to Variable< 1 %Database Table Creator< 1 %Table Writer< 1 %- Recursive Loop End< 1 %
Variable Loop End< 1 %- Parallel Chunk End< 1 %
- DB Update< 1 %
- TIBCO Spotfire File Writer< 1 %
IF Switch (Flow Variable Value)< 1 %- Decision Tree Predictor< 1 %
Gradient Boosted Trees Predictor< 1 %- Double to Integer< 1 %
- Duplicate Row Filter< 1 %
- Row Filter (Labs)< 1 %
- Number Rounder< 1 %
- String Manipulation (Variable)< 1 %
- Extract Table Dimension< 1 %
- SDF Writer< 1 %
- DB Connector< 1 %
Table to HTML< 1 %Excel Writer (XLS)< 1 %- String to Date/Time (legacy)< 1 %
Variable to Table Column< 1 %Variable to Table Column< 1 %Table Row To Variable Loop Start< 1 %- k-Means< 1 %
- Add Empty Rows< 1 %
- Column Comparator< 1 %
- Column Renamer (Dictionary)< 1 %
- Reference Row Splitter< 1 %
- Unpivot< 1 %
- Color Manager< 1 %
- Interactive Table (legacy)< 1 %
- Molecule Type Cast< 1 %
Excel Sheet Appender (XLS)< 1 %- Google Sheets Updater< 1 %
- Table to JSON< 1 %
- JSON Path< 1 %
Python Script (1⇒1)< 1 %- R Snippet< 1 %
- Modify Time< 1 %
Table to HTML String< 1 %- RDKit To InChI< 1 %
Loop End (Upto 6 ports)< 1 %- Benchmark End< 1 %
- Combine Columns by Header< 1 %
- Breakpoint< 1 %
- Try (Data Ports)< 1 %
- Active Branch Inverter< 1 %
Table Column to Variable< 1 %Variable to Table Row< 1 %CSV Writer< 1 %Database Update< 1 %- Java Edit Variable< 1 %
- Loop End (Column Append)< 1 %
- Group Loop Start< 1 %
Recursive Loop End< 1 %- Variable Loop End< 1 %
- X-Aggregator< 1 %
- Decision Tree Learner< 1 %
K Nearest Neighbor< 1 %- MultiLayerPerceptron Predictor< 1 %
Scorer< 1 %Tree Ensemble Predictor (Regression)< 1 %Gradient Boosted Trees Predictor< 1 %- PMML Gradient Boosted Trees Predictor< 1 %
- Perl Scripting< 1 %
- Auto-Binner< 1 %
- Cell Splitter< 1 %
- Column Auto Type Cast< 1 %
- Column Combiner< 1 %
- Column Rename (Regex)< 1 %
- Cross Joiner< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Equal Size Sampling< 1 %
- Filter Apply Row Splitter< 1 %
- Interactive HiLite Collector< 1 %
- Nominal Value Row Filter< 1 %
- Normalizer< 1 %
- Pivot< 1 %
- String Splitter (Regex)< 1 %
- Row Sampling< 1 %
- Rule Engine (Dictionary)< 1 %
- Numeric Outliers< 1 %
- Independent groups t-test< 1 %
- Statistics< 1 %
CASE Switch Data (Start)< 1 %Merge Variables< 1 %- Line Plot (legacy)< 1 %
- ROC Curve (legacy)< 1 %
- SDF Stripper< 1 %
- Parallel Chunk Start< 1 %
DB Loader< 1 %- Parameterized DB Query Reader< 1 %
- DB SQL Executor< 1 %
- DB Table Remover< 1 %
- String Distances< 1 %
- Similarity Search< 1 %
- Variable Expressions< 1 %
- Math Formula (Multi Column)< 1 %
- Line Chart (JFreeChart)< 1 %
XLS Sheet Appender< 1 %XLS Writer< 1 %Excel Reader (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- String to Path< 1 %
- JPMML Classifier< 1 %
- Container Output (Table)< 1 %
- Python View (legacy)< 1 %
- Add Table to R< 1 %
- Table Difference Checker< 1 %
- Date&Time Difference< 1 %
- Date&Time-based Row Filter< 1 %
- Date&Time Shift< 1 %
- Time Difference (legacy)< 1 %
- Time Generator (legacy)< 1 %
Views
- This node has no views
Workflows
01_Validating_DatatablesKNIME Hub- 02_Accounting ManagementKNIME Hub
- 02_Data_Manipulation_Exercise_1_BKNIME Hub
- 02_Data_Manipulation_Exercise_1_CKNIME Hub
- 02_Data_Manipulation_Exercise_1_DKNIME Hub
- Show all 51 workflows
Links
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.