Table Validator (Reference)

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.

Input ports

1. Type: Table
   Table to validate
   Table to be validated.
2. Type: Table
   Reference Table
   Table that is used as the reference.

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.