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.
Data Validation Multiple

Reading from CSV File

DatasetCSV processor reads data from a CSV file.

Processor Configuration

Data Validation Multiple

Processor Output

Data Validation Multiple

String Functions

StringFunctions processor performs specified operation on the selected column (i.e. trim function for column ‘name’ in this case)

Processor Configuration

Data Validation Multiple

Processor Output

Data Validation Multiple

Performing Validation

ValidationMultiple processor performs different validation on different columns.

Processor Configuration

Data Validation Multiple

Processor Output

Data Validation Multiple

Prints the Valid Records

Processor Output

Data Validation Multiple

Prints the Invalid Records

Processor Output

Data Validation Multiple