4.6. Validation node
Icon: 
Number of inputs: 1.
Number of outputs: 1 or 2.
- Definition
A validation node sends valid records to its first output and invalid records to its second output, if there is one.
- Configuration
Two types of validation are available:
Validation by field (Field validation rules tab
). Check performed for each selected field:Type:
where cells contain a value not recognized as valid, the record concerned will be sent to the second output of the node (= invalid records).
Nature:
where cells contain a value not recognized as valid, the record concerned will be sent to the second output of the node (= invalid records).
Presence:
where cells do not contain a value, the record concerned will be sent to the second output of the node (= invalid records).
Check of field validation rules as defined in an upstream preparation function:
in the specified field, where cells contain a value that is invalid under the rule (e.g. list of permitted values or validity interval), the relevant record will be sent to the second output of the node (= invalid records).
Validation by record (Row validation rules tab,
).Record validity will be checked for each ticked rule. Invalid records will be sent to the second output of the node (= invalid records). Record validation rules must be attached to an upstream preparation node.
- Example
In this example, validation by field has been set up to check each field for:
Type. In this date field, where cells contain a value that is not recognized as a valid date, the relevant record will be sent to the second output of the node (= invalid records).
Nature. In this field identified as containing emails, where cells contain a value that is not recognized as a valid email, the relevant record will be sent to the second output of the node (= invalid records).
Presence: Where cells do not contain any value, the relevant record will be sent to the second output of the node (= invalid records).