This node ensures a certain table structure and table content using a reference data table specification defined by the user in the configuration dialog. The base for the configuration is given by the specification of the input table during configuration and provides the basic template for the output table. It is ensured that the result table structure is mostly identical to the specification defined by the user. 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 for each column (or a group of them) if it is required and if the data type or the domain should be checked/converted. To make use of this second approach, select a column or a list of columns to be handling, drag them to the appearing "+" button, and set the parameters. To remove this extra handling (and instead use the default handling), click the "Remove" button for this column. If the validation succeeds, data gets output to the first port (potentially renamed, sorted according to the user defined 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
Reference Spec
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
Column Rename2 %Scorer2 %- Concatenate2 %
- Table Manipulator2 %
- Column Filter2 %
Excel Reader (XLS)2 %Joiner2 %- CSV Reader2 %
- Joiner1 %
- Constant Value Column1 %
- Pivot1 %
- String Splitter (Regex)1 %
- Excel Reader1 %
- Column Auto Type Cast1 %
- Catch Errors (Data Ports)1 %
- Table Transposer1 %
- Empty Table Switch1 %
XLS Reader1 %- String to Number1 %
Row Filter (deprecated)1 %Read Excel Sheet Names (XLS)1 %- Auto-Binner< 1 %
- Column Resorter< 1 %
- Table Validator< 1 %
- End IF< 1 %
- Add Empty Rows< 1 %
Number To String< 1 %- Table Creator< 1 %
- Statistics< 1 %
- String to Date&Time< 1 %
- Table Row to Variable< 1 %
- File Reader< 1 %
String To Number< 1 %- Create Table Structure< 1 %
- Rule Engine< 1 %
- Extract Table Spec< 1 %
- Math Formula< 1 %
- Variable to Table Row< 1 %
- Table Writer< 1 %
Loop End< 1 %- Column Merger< 1 %
- Cross Joiner< 1 %
- CAIM Binner< 1 %
- CASE Switch Start< 1 %
- Workflow Executor< 1 %
- Loop End< 1 %
- Try (Data Ports)< 1 %
Variable to Table Column< 1 %- Java Snippet< 1 %
- Column Rename (Regex)< 1 %
- Filter Apply< 1 %
- Reference Row Filter< 1 %
- Missing Value (Apply)< 1 %
- Column Appender< 1 %
Row Splitter (deprecated)< 1 %- IF Switch< 1 %
- DB Reader< 1 %
- Column Expressions (legacy)< 1 %
- Column Renamer< 1 %
- CASE Switch End< 1 %
Concatenate (Optional in)< 1 %- Column Name Extractor< 1 %
- Table Validator (Reference)< 1 %
- Missing Value Column Filter< 1 %
- GroupBy< 1 %
- Missing Value< 1 %
- RowID< 1 %
- Set Operator< 1 %
- Column Splitter< 1 %
- String Manipulation< 1 %
- Value Counter< 1 %
- Rule-based Row Filter< 1 %
- Empty Table Creator< 1 %
- Java Snippet (simple)< 1 %
- Table View (JavaScript)< 1 %
- JSON to Table< 1 %
- Case Converter< 1 %
- Cell Splitter< 1 %
- Number to String< 1 %
- Domain Calculator< 1 %
- Double to Integer< 1 %
- Duplicate Row Filter< 1 %
- Nominal Value Row Filter< 1 %
- Sorter< 1 %
- String Manipulation (Multi Column)< 1 %
- DB Query Reader< 1 %
- Table Reader< 1 %
- Table Difference Finder< 1 %
- Table Editor (JavaScript)< 1 %
- Table to HTML String< 1 %
- Columns to JSON< 1 %
- Split Collection Column< 1 %
File Reader< 1 %- Linear Regression Learner< 1 %
- Interactive HiLite Collector< 1 %
- Normalizer< 1 %
- Partitioning< 1 %
- Color Manager< 1 %
- PDF Parser< 1 %
- R Source (Table)< 1 %
- GET Request< 1 %
- Group Loop Start< 1 %
- String Replacer< 1 %
Excel Reader (XLS)< 1 %Variable to Table Row< 1 %Database Connection Table Reader< 1 %Database Reader< 1 %Logistic Regression Learner< 1 %Cell Replacer< 1 %- Number to Category (Apply)< 1 %
- Time to String (legacy)< 1 %
Naive Bayes Learner< 1 %- Decision Tree Predictor< 1 %
- String Manipulation (Variable)< 1 %
- Rule Engine Variable< 1 %
- JSON Path< 1 %
JSON Reader< 1 %- Row Filter (Labs)< 1 %
- R Snippet< 1 %
- Create Collection Column< 1 %
Database Update< 1 %Line Reader< 1 %- Fuzzy Rule Learner< 1 %
Column Appender< 1 %- Edit Nominal Domain< 1 %
- Unpivot< 1 %
Binary Objects to Files< 1 %Table Column to Variable< 1 %Table Column to Variable< 1 %Table Row to Variable< 1 %Line Reader< 1 %- Logistic Regression Predictor< 1 %
- Edit Numeric Domain< 1 %
- Subset Matcher< 1 %
- Number Rounder< 1 %
- Ruleset to Table< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Container Input (Table)< 1 %
- Container Input (JSON)< 1 %
- R to Table< 1 %
- Date&Time-based Row Filter< 1 %
Table Extractor< 1 %- Strings to Binary Objects< 1 %
- Loop End (Column Append)< 1 %
- Rule-based Row Splitter< 1 %
- Wait...< 1 %
CSV Reader< 1 %Table Reader< 1 %Counting Loop Start< 1 %- Chunk Loop Start< 1 %
- X-Partitioner< 1 %
- Column Renamer (Dictionary)< 1 %
- Many to One< 1 %
- Reference Row Splitter< 1 %
- Shuffle< 1 %
- Cache< 1 %
- Data Generator< 1 %
- SDF Inserter< 1 %
Excel Reader (XLS)< 1 %- Python Source (legacy)< 1 %
- R Predictor< 1 %
Extract Date&Time Fields< 1 %- String to Date/Time (legacy)< 1 %
- XPath< 1 %
- Text Classifier Predictor< 1 %
- Download (legacy)< 1 %
- List Remote Files (legacy)< 1 %
Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %- ARFF Reader< 1 %
- Fixed Width File Reader< 1 %
List Files< 1 %Recursive Loop Start< 1 %- PNN Predictor< 1 %
- Silhouette Coefficient< 1 %
- Hierarchical Cluster Assigner (local)< 1 %
- k-Means< 1 %
- DBSCAN< 1 %
- MultiLayerPerceptron Predictor< 1 %
PCA< 1 %- SMOTE< 1 %
- Tree Ensemble Model Extract< 1 %
- Simple Regression Tree Predictor< 1 %
- Numeric Binner< 1 %
- Column Combiner< 1 %
- Column Comparator< 1 %
- Column Aggregator< 1 %
- Lag Column< 1 %
- One to Many< 1 %
- Reference Column Filter< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply Row Splitter< 1 %
- Row Sampling< 1 %
- Target Shuffling< 1 %
- Ungroup< 1 %
- Rule Engine (Dictionary)< 1 %
- Data Explorer< 1 %
CASE Switch Data (End)< 1 %CASE Switch Data (Start)< 1 %- Extract Table Dimension< 1 %
Color Appender< 1 %- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
- Math Formula (Multi Column)< 1 %
- Index Query< 1 %
- Tika Parser< 1 %
- Strings to Document< 1 %
- List Box Configuration< 1 %
- String Configuration< 1 %
- Column Filter (legacy)< 1 %
- Range Slider Filter Definition (legacy)< 1 %
- Value Filter (legacy)< 1 %
- Table to JSON< 1 %
- JSON Schema Validator< 1 %
- POST Request< 1 %
- Fail in execution< 1 %
- Date&Time Difference< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Window Loop Start< 1 %
- Time Generator (legacy)< 1 %
- Twitter Search (legacy)< 1 %
XML Reader< 1 %IF Switch (Flow Variable Value)< 1 %- MolConverter< 1 %
- Try (Variable Ports)< 1 %
- Inject Variables (Data)< 1 %
- Table Column to Variable< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- Table Row to Variable Loop Start< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Category to Number< 1 %
- Extract Missing Value Cause< 1 %
- Molecule Type Cast< 1 %
- Java Edit Variable (simple)< 1 %
- Java IF (Table)< 1 %
- String Matcher< 1 %
- List Files/Folders< 1 %
- Transfer Files< 1 %
- File Chooser Widget< 1 %
- JSON Path (Dictionary)< 1 %
- Date&Time to String< 1 %
- Create Date&Time Range< 1 %
Regex Extractor< 1 %
Views
- This node has no views
Workflows
00 Main MenuKNIME Hub- 00 Main MenuKNIME Hub
- 01 Data validation & Statistics Process ControlKNIME Hub
- 01 Data validation & Statistics Process ControlKNIME Hub
- 01 Data validation & Statistics Process ControlKNIME Hub
- Show all 475 workflows
Links
- Possible to create a popup messageby ipazin on 2019-03-07forum.knime.com/p/55746
- Empty table switchby izaychik63 on 2022-07-22forum.knime.com/p/164080
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.