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 Predecessors
- Table Creator8 %
- Column Filter6 %
Excel Reader (XLS)5 %- Excel Reader4 %
Column Rename3 %- Rule Engine3 %
- Column Expressions3 %
String To Number3 %Number To String2 %- Constant Value Column2 %
Row Filter (deprecated)2 %- Number to String1 %
- Loop End1 %
- CSV Reader1 %
Column Appender1 %- Concatenate1 %
- Double to Integer1 %
- Math Formula1 %
- Modify Date1 %
- Table Reader1 %
- String to Date&Time< 1 %
- Date&Time to legacy Date&Time< 1 %
- Table Manipulator< 1 %
- String Manipulation< 1 %
- String to Number< 1 %
- DB Query Reader< 1 %
- Column Renamer< 1 %
- Column Resorter< 1 %
- Missing Value< 1 %
- Joiner< 1 %
Database Reader< 1 %- Correlation Filter< 1 %
- Table Validator< 1 %
- Reference Column Filter< 1 %
- Table Transposer< 1 %
Excel Reader (XLS)< 1 %- Domain Calculator< 1 %
- Extract Table Dimension< 1 %
Read Excel Sheet Names (XLS)< 1 %Table Reader< 1 %- Column Renamer (Dictionary)< 1 %
- RowID< 1 %
- Empty Table Creator< 1 %
Cell Replacer< 1 %- Reference Row Filter< 1 %
Excel Reader (XLS)< 1 %- Column Auto Type Cast< 1 %
- Create Table Structure< 1 %
- Table Validator (Reference)< 1 %
- Missing Value Column Filter< 1 %
- Pivot< 1 %
- Rule-based Row Filter< 1 %
- Modify Time< 1 %
Database Connection Table Reader< 1 %- Add Empty Rows< 1 %
- Column Merger< 1 %
Row Splitter (deprecated)< 1 %- GroupBy< 1 %
- Rule-based Row Splitter< 1 %
- Statistics< 1 %
CASE Switch Data (End)< 1 %- Date&Time to String< 1 %
- Table Difference Finder< 1 %
- Molecule Type Cast< 1 %
- Row to Column Names< 1 %
- Inject Variables (Data)< 1 %
- Catch Errors (Data Ports)< 1 %
- Try (Data Ports)< 1 %
- Numeric Binner< 1 %
- Column Name Extractor< 1 %
- Column Rename (Regex)< 1 %
- Cross Joiner< 1 %
- Nominal Value Row Filter< 1 %
Joiner< 1 %- Low Variance Filter< 1 %
- Sorter< 1 %
- String Replacer< 1 %
- Empty Table Switch< 1 %
- Extract Table Spec< 1 %
- Math Formula (Multi Column)< 1 %
- String to Date/Time (legacy)< 1 %
- One to Many< 1 %
- Reference Column Splitter< 1 %
- Missing Value (Apply)< 1 %
- Reference Column Resorter< 1 %
- Number Rounder< 1 %
- Ungroup< 1 %
- DB Reader< 1 %
- File Reader< 1 %
- Column Appender< 1 %
- Duplicate Row Filter< 1 %
- One to Many (PMML)< 1 %
- Row Sampling< 1 %
- String Manipulation (Multi Column)< 1 %
- DB Writer< 1 %
- Integer Configuration< 1 %
- Date&Time-based Row Filter< 1 %
- R Source (Table)< 1 %
- SAP Reader (Theobald Software)< 1 %
- Parallel Chunk End< 1 %
- Path to String< 1 %
- Java Snippet< 1 %
- Group Loop Start< 1 %
Scorer< 1 %Concatenate (Optional in)< 1 %- Legacy Date&Time to Date&Time< 1 %
- Split Collection Column< 1 %
- Value Counter< 1 %
Table Row to Variable< 1 %- Partitioning< 1 %
CSV Reader< 1 %File Reader< 1 %- Reference Row Splitter< 1 %
XLS Reader< 1 %Recursive Loop Start< 1 %- R Snippet< 1 %
- Normalizer (Apply)< 1 %
- Column Filter (legacy)< 1 %
- Boolean Widget< 1 %
- Date&Time Part Extractor< 1 %
- Active Branch Inverter< 1 %
Variable to Table Row< 1 %- Constant Value Column Filter< 1 %
- Column Splitter< 1 %
- Numeric Outliers (Apply)< 1 %
- End IF< 1 %
- Data Generator< 1 %
- Counter Generation< 1 %
Python Script (1⇒1)< 1 %- Remove Empty Rows< 1 %
- Interactive HiLite Collector< 1 %
- Container Input (Table)< 1 %
- Create Date&Time Range< 1 %
Simple File Reader< 1 %- String Splitter (Regex)< 1 %
- Google Sheets Reader< 1 %
- HTML Node to Text< 1 %
- TIBCO Spotfire File Reader< 1 %
Loop End< 1 %- Column Combiner< 1 %
- Edit Nominal Domain< 1 %
Double To Int< 1 %- Filter Apply< 1 %
- Normalizer< 1 %
- Unpivot< 1 %
Rank Correlation< 1 %- Numeric Outliers< 1 %
- IF Switch< 1 %
- Color Manager< 1 %
- SDF Reader< 1 %
Python Script (2⇒1)< 1 %- Mask Date/Time (legacy)< 1 %
- RDKit Interactive Table< 1 %
- Random Numbers Generator< 1 %
- Create Collection Column< 1 %
- Copy/Move Files (legacy)< 1 %
Table Row to Variable< 1 %Variable to Table Row< 1 %Loop End (2 ports)< 1 %- Loop End (Column Append)< 1 %
Variable Condition Loop End< 1 %Recursive Loop Start (2 ports)< 1 %- Decision Tree Predictor< 1 %
- Column Aggregator< 1 %
- Nominal Value Row Splitter< 1 %
- Subset Matcher< 1 %
- Numeric Row Splitter< 1 %
String Replace (Dictionary)< 1 %- Ruleset to Table< 1 %
- Lift Chart (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Scorer (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- UNIX Timestamp to Date&Time< 1 %
- RDKit Descriptor Calculation< 1 %
- Strings to Binary Objects< 1 %
- Variable to Table Column< 1 %
- Read Images< 1 %
- File Reader (Complex Format)< 1 %
- Perl Scripting< 1 %
- Column Comparator< 1 %
- Edit Numeric Domain< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
Merge Variables< 1 %- Workflow Executor< 1 %
- DB Insert< 1 %
- DB Loader< 1 %
- DB Update< 1 %
- Columns to JSON< 1 %
- String to XML< 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.