Multi-Validation Workflow¶
This workflow performs multiple validations on each incoming record
- Records which pass validation are output into the first edge
- Records which fail validation are output into the seconds edge
Validations¶
- Ensures that field is greater than or equal to specified string value
- Ensures that field is less than or equal to specified string value
- Ensures that field matches given datePattern
- Ensures that the email is valid
- Ensures field length is greater than or equal to specified length
Workflow¶
Below is the workflow. It does the following:
- Reads data from a CSV file.
- Performs specific validation on specific columns.
Reading from CSV File¶
DatasetCSV processor reads data from a CSV file.
Processor Configuration¶
Processor Output¶
String Functions¶
StringFunctions processor performs specified operation on the selected column (i.e. trim function for column ‘name’ in this case)