Special values

Imported data tables may contain special values to signify absent, not recorded, trace or below detection limit values. For example, an assay value of -1 in the Ag field might signify "not recorded" and a value of -9 in the Fe field might signify "below detection limit".

To set data conversions:

1. Import the table.

2. Choose Data >> Set Conversions to display the Data Conversions screen.

3. In the Column box, select the Table and Column name, or check Apply to All Columns.

4. In the Value box, type the special value you wish to convert.

5. Type the value you wish to convert to in the Convert To box, or select one of the special value symbols by clicking the down arrow button:

6. Click Add.

7. Repeat steps 3 to 6 for each value conversion required in each field in each table.

8. Choose OK to apply conversions.

The data conversions are saved in the document and applied to the imported tables whenever the document is opened.  

Related topics and activities:

• Drillhole Data Validation