Follow-On Topics

Related Topics

# Using Validation

The Validation dialog box is displayed by clicking on the Validations button in the Elements / Columns tab. It is used is to create one or more rules to validate the data contained in the source file(s) at Task run time. This enables capturing of any errors at the earliest possible time in a Task to enable the source data to be corrected if necessary. NOTE: If the XML output option has been selected in the Main tab then any data validation rules created in the Data Validation dialog box are applied against the complete dataset in one operation at Task run time. If the Recordset output option has been selected in the Main tab then any data validation rules created in the Data Validation dialog box are applied against each record in the recordset as it is processed by the subsequent consuming Step at Task run time. The dialog box contains a number of fields, listed below, which can be used in a logical sequence to build a single or multiple rules:
|  | And / Or — Blank (empty), And or Or may be selected. Selecting an And or Or value for this field creates another line of fields on the dialog box to enable another rule to be appended.
| Click the image to view full size.

|  | Open Bracket — Blank (empty) or Open Bracket ( may be selected. Nested brackets are not permitted.

|  | Name — The name of the Node or Element.

|  | Operator — A drop down list of operators is provided for selection:

|  | Equals

|  | Starts With

|  | Contains

|  | Ends With

|  | Greater Than

|  | Less Than

|  | Between

|  | Not Equal To

|  | Not Starting With

|  | Not Containing

|  | Not Ending With

|  | Is Not Between

|  | Is One Of

|  | Is Not One Of

|  | Is Null

|  | Is Not Null

|  | Value 1 — The value to be compared. Values may be dragged and dropped into the field from the Task Browser dialog box to provide dynamic content.

|  | Value 2 — The second value to be compared. This field appears when an operator is selected that requires two entries (Between and Is not between). Values may be dragged and dropped into the field from the Task Browser dialog box to provide dynamic content.

|  | Close Bracket — Blank (empty) or Close Bracket ) may be selected. Only active if a matching open bracket is present. Nested brackets are not permitted.

|  | Remove all validations — Clicking on this button removes all of the data validations added into the dialog box. A warning dialog box initially pops up to ask you to validate the request.

Copyright © 2018 Quadrant Software B.V. All rights reserved.