Icon

01_​Validating_​Datatables

Table Validator - ensures a certain table structure

Table Validator node: checks incoming table specs depending on the node configration and forwards it to first output port (if valid) or the second (if invalid).
Table Validator (Reference) node: similar to Table Validator node but checks table spec of the table that goes into the first input port against the spec of the reference table from the second input port.
If the Column Filter node is removed the the incoming table will be regarded as valid.

This workflow demonstrates how a certain table structure can be ensured with the help of the Table Validator node(s).For more detailed information see the workflow metadata. Find it here: View -> Description checks table spec by configurationif valid: table forwarded to first output portif invalid: table forwarded to second output portdo something withthe VALID tabledo somethingwith the INVALID tableremoves a columnsuch that the tablestructure is not valid anymorechecks table spec againstreference table spec provided by second input port Table Validator Table Creator Row Filter ConstantValue Column Column Filter Table Validator(Reference) This workflow demonstrates how a certain table structure can be ensured with the help of the Table Validator node(s).For more detailed information see the workflow metadata. Find it here: View -> Description checks table spec by configurationif valid: table forwarded to first output portif invalid: table forwarded to second output portdo something withthe VALID tabledo somethingwith the INVALID tableremoves a columnsuch that the tablestructure is not valid anymorechecks table spec againstreference table spec provided by second input port Table Validator Table Creator Row Filter ConstantValue Column Column Filter Table Validator(Reference)

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Berthold
Created at: 2015-12-08
On NodePit since: 2025-02-18
Last update: 2026-04-10
Created with KNIME version: v4.1.0
Tags: ETLvalidationtable structuretable validation

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!