Data Validator

Description

Data Validator is a step in the Validation Plugin for Process Studio Workflows. Data Validator step validates data from the input stream against a set of validation rules on the data type and the data. An unlimited number of validation rules can be set. This ensures the quality of data from the input stream. Data validations can include a value range, a distinct list of values or data lengths etc

Configurations

No.	Field Name	Description
1	Step name	Specify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow.
2	Report on all errors, not only the first	Enable checkbox to report on all errors.
3	Output one row, concatenate errors with separator	Output one row, concatenate errors with separator is enabled When Report on all errors, not only the first above is enabled. Enable this checkbox to concatenate all errors and specify the separator.
	Validations:	The fields appear after you add a validation, using New validation. Click Remove validation to delete the selected validation from the list.
4	Validation Description	Displays the name of the validation. You can modify the name of validation, if required.
5	Name of the fields to validate	Click Add to select the fields you want to validate from the List of fields dialog. OR Click Add manually to add name of the field you want to validate. Click Remove to delete the selected field from the list.
6	Error code	Specify the error code to pass to error handling for this validation rule.
7	Error description	Specify the error description to pass to error handling for this validation rule.
8	Data type	- Verify data type?: Check this if you want to specify a certain data type to match. - Data type: Specify the data type of the data specified in this dialog or the data type to verify. - Conversion mask: Specify the mask to use to convert the data specified in this validation rule. - Decimal Symbol: Specify the decimal symbol to use to convert the data specified in this validation rule. - Grouping Symbol: Specify the grouping symbol to use to group the data in the validation rule.
9	Values	This block of information contains the actual bulk of the validation rule - Null allowed?: Select the checkbox if you don't want to allow null values in the data for the selected field. - Only null values allowed?: Select the checkbox if you want to allow null values only. - Only numeric data expected?: Select the checkbox if you expect only numeric data to be available. - Min string length: Verify the length of the string-form of the data of the selected field, make sure it's longer than or as long as the length specified here. - Max string length: Verify the length of the string-form of the data of the selected field, make sure it's shorter than or as long as the length specified here. - Minimum value: Verify the data of the selected field and see if it's not lower than the minimum value specified here. - Maximum value: Verify the data of the selected field and see if it's not higher than the maximum value specified here. - Expected start string: the string value of the value we validate needs to start with this value (when specified). - Expected end string: the string value of the value we validate needs to end with this value (when specified). - Not allowed start string: the string value with which the value to be validated must not start. - Not allowed end string: the string value with which the value to be validated must not end. - Regular expression expected to match: the string value of the value we validate needs to match this regular expression (when specified) - Regular expression not allowed to match: the string value of the value we validate is not allowed to match this regular expression (when specified) - Read allowed values from another step?: enable this option to source the data from another step in the workflow. - This effectively removes the need to hard code allowed values. You can now store them in a database table or a file somewhere.You also need to specify the step and field to read from if this option is selected. IMPORTANT: For every validation that sources data you need to specify a different step to read from. - The step to read from: select the step from which to read the value to be validated. - The field to read from: select the field to be validated from the selected step. - Allowed values: Make sure that the data of the selected field is only one of the values in the list. You can use the buttons to the right to add or remove values from the list. - Click Add to manually add allowed values. - Click Remove to delete the allowed values.