User Guide › Design › Data Acquisition › Adapters › Adding Adapters › Add a Text File Adapter › Input Toolbar › Input Validation

Input Validation

The purpose of the validation is to perform quality checks for the input data or to perform initial filtering of the input. Records that were found as illegal can be saved into output files according to a definition in the General step.

In the Input Validation window:

1. In Valid by default:
   • Select Yes to define the default case as the validator if a conclusion cannot be reach by the validation cases defined.
   • Select No to have validation performed by the validation cases only.
2. If necessary, in Validation cases table, specify if the input row is valid or not based on a set of conditions.

To add validation cases:

1. In Validation cases table, click Add case. The Validation case details page is displayed.
2. In Valid:
   1. Select Yes to have the input considered valid if the condition is met.
   2. Select No to have the input considered not valid if the condition is not met.
3. In stop when true:
   1. Select Yes to not go to the next case if the condition is met.
   2. Select No to continue to the next case if the condition is met.
4. In conditions logical operator:
   1. Select All conditions must be met (And) to specify that all the conditions set for the case must be met in order to consider it valid.
   2. Select At least one condition should be met (Or) to specify that at least one of the conditions set for the case must be met in order to consider it valid.
5. If necessary, click Add Condition to create the condition to be tested on a data row so as to determine its validity. The following row of fields is displayed.
   1. Fill in the columns as follows:
   • Source Field - Select the field to be tested.
   • Operator - Select a test type from the following options: = (Equal to), <> (Not equal to), > (Greater than), >= (Greater or equal to), < (Less than), <= (Less or equal to), Match (A regular expression should be matched. For more information on regular expression syntax, see Regular Expression Syntax), Unmatch (A regular expression should not match. For more information on regular expression syntax, see Regular Expression Syntax).
   • Match Case - Select this check box to define if the testing is case sensitive. When cleared, the two values are translated to lower case before the test. This field is relevant only when Operator is set to Match or Unmatch.
   • Value Type - Select the value type: Constant (The comparison is performed according to the value given in the Constant column), Field (The value of the selected Source Field is compared to another field (specified in the Field column) of the same type in the same record), Last Value of (The value of the selected Source Field is compared to another field (specified in the Field column) of the same type in the previous record).
   • Constant - Type the value of the constant. This field is enabled when Value Type is set to Constant.
   • Field - Select the field (created in the Details tab) from the drop-down list.
   1. Click to cancel the operation.
   2. Click to update. The Validation case details page is displayed showing the added condition.
6. If necessary, repeat step 5 to add more conditions.

   Note: The order of the conditions can be changed by clicking or next to the desired condition.

7. Click OK. The Validation tab is displayed showing the added case.
8. If necessary, click Add case and repeat steps 1-6 to add more cases.

   Note: The order of the validation cases can be changed by clicking or next to the desired case.

9. Click to delete the case.
10. Click to edit the case.