Table Validator

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.

Input ports

1. Type: Table
   Table to validate
   Table to be validated.

Output ports

1. Type: Table
   Validated table
   Table with corrected and validated structure. Depending on the validation result and the Behavior if validation fails settings, this port may be inactive.
2. Type: Table
   Validation fault table
   Table where missing values have been handled. Depending on the validation result and the Behavior if validation fails settings, this port may be inactive.