Table Structure Validator

This node ensures the input table meets the reference structure as defined in the node. You may use the current input table’s structure as a template during configuration. As a result, the output table’s structure is identical to the defined reference in all relevant aspects.

You can choose whether columns and types need to match the reference structure exactly. Alternatively, columns can be renamed, inserted (filled with missing values), sorted, removed, as well as their type changed to align with the reference.

If the validation succeeds, the validated and aligned table is output to the first port.

If the validation fails, you can choose to output a list of all conflicts at the second port (the first port is inactive) or make the node fail.

Options

Reference structure
Define the reference structure to validate against by specifying the expected columns and their types.
  • Column name: The name of the reference column to validate against.
  • Column type: The type of the reference column to validate against.
Set input table as template
Sets the input table specification as reference structure template.
If column name casing differs
Controls what counts as a column name match between the input table and the reference table. If 'Rename' is chosen, it still tries to treat the column name as a distinct value (find an exactly case-sensitive matching column name) first, and then falls back to renaming the column (case-insensitive matching).
  • Treat as distinct: Column names must match exactly
  • Rename: Also columns whose name matches case insensitively will be considered to be validated.
If a column is not in the table
Ensures that the configured columns exist in the input table. If case insensitive name matching is selected, the first matching column will satisfy this condition.
  • Fail validation: Fails the validation if columns don't exist
  • Ignore: Ignore missing columns and do nothing
  • Insert with missing values and move to end: Inserts missing columns at the end of the table and fills them with missing values
If there is an additional column in the table
Specifies how to handle columns which are not included in the reference structure but present in the table to validate.
  • Fail validation: Additional columns will cause the validation to fail
  • Remove: Additional columns will be removed
  • Move to end: Additional columns will be moved to the end of the table
If data type does not match
Ensures correct data type for the columns.
  • Fail validation: Fails the validation if reference data type is not a super type of the data type to validate
  • Ignore: Ignores data type mismatches and do nothing
  • Try to convert: Attempts conversion and fails the validation if not possible
If validation fails
Controls how validation faults should influence the workflow execution.
  • Fail node: Forces the node to fail if the validation fails, with detailed validation fault descriptions.
  • Deactivate first output port: Never fails but deactivates first output port if the validation fails and outputs results at the second port.

Input Ports

Icon
Table to be validated.

Output Ports

Icon
Table with corrected and validated structure. Depending on the validation result and the If validation fails settings, this port may be inactive.
Icon
Table containing the column names that failed validation, an error, and an error description. Depending on the validation result and the If validation fails settings, this port may be inactive.

Popular Predecessors

  • No recommendations found

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

  • No workflows found

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.

Installation

To use this node in KNIME, install the extension KNIME Base nodes from the below update site following our NodePit Product and Node Installation Guide:

v5.12

A zipped version of the software site can be downloaded here.

Plugin provider: KNIME AG, Zurich, Switzerland
Plugin version: 5.12.0.v202606261225
On NodePit since: 2026-08-08
Last update: 2026-08-13
Tags: StreamableModern UI
KNIME versions: Since v5.11

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

Try NodePit Runner!