Validate
This option is also available on the Lookup Table Editor tab for Lookup Tables.
When you run this function, data in the chosen fields is validated against the data in your check file. A report is then generated with detailed information on the results of the validation. Your data in both the input and check files remains unchanged.
You can also check numeric values against a minimum and maximum range.
Another example where you can use validation is to check the lithological names you have in a file. You would then set up a check file with all allowable names, and use it to compare your entries against that check.
When validating drillhole data, the Hole, From and To fields you specify are used to reference errors in the Report file. To check for logical sequence errors in your From and To values, use the Drillhole Validation tool (on the Drillhole tab, in the Validation group) instead.
Input file
In the Input section, enter the name of the file to be validated. Define a filter to selectively control which records will be processed.
Data Type
To validate files with FROM and TO fields (e.g. Drillholes), select DRILLHOLE from the Data type list and enter the name of the hole field and the fields containing the From and To measurements of the sample. If you want to validate any other type of data, select GENERAL.
Check file
Double-click (or click on the Select icon) to select the name of the Check file that contains the permitted values against which you want to compare your data.
Report file
Specify the name of the Report file where you want to store the results of the validation. The report file will only contain details of the fields that do not pass the validation. If this file does not yet exist it will be created. Error messages generated during the validation process are written to this file and displayed in a Report Viewer.
Fields to validate
The fields you want to validate can be defined on each row of the grid list. Use the buttons on the local toolbar to Manage the rows in the list.
For each field that need to be validated in the Input file, specify the field name, the Minimum and Maximum values they can contain, and the name of the Check fields (in the Check file) that contain the acceptable values. (Minimum and maximum fields may only be entered for Numeric values. You can also apply a Check file to Numeric fields, but still need to enter values in the Minimum and Maximum fields).
Ignore blanks
Select this option if you want the validation to ignore blank values.
Case sensitive
Select this option if you want the validation to be case sensitive.
Note: You can also validate fields when a file is open in the File Editor. See: Validate