Combining Drilling Data Sets

A combined drilling data set is built from other drilling data sets in the project. You can create a combined drilling data set from interval values, downhole points, downhole structural data and screens data already imported into the project. Data from merged tables, evaluation tables, composite tables and interpretation tables can also be used in a combined drilling data set.

As with imported drilling data sets, a combined drilling data set is made up of a collar file, a survey file and at least one other table. Information in each type of table is built up from the source data sets, which are linked to from the combined data set. In this example, a combined data set has been created from two lithology tables. The combined collar table and the combined survey table have been created from the corresponding tables in the source data sets.

Data from the source tables is used in the combined data set as follows:

When the same data appears in more than one source table, all instances of the data are included in the combined data set but the rows from lower priority tables are marked in the combined table as ignored.
Where data in a source table is marked as ignored, it is not included in the combined data set.
If a row in the source tables is in error, that row will be included in the combined data set but the combined table will be marked as having an error (). The error can only be corrected in the source table.
When special value handling rules have been applied to the data in the source table, the results of the rule being applied will be used in the combined table.

This example shows the collars for two drilling data sets, each with two boreholes, an assay table and a lithology table. The first set has WP001 and WP002 boreholes and the second has WP002 and WP003 boreholes:

The collar information from each data set is used to build the combined collar table, with duplicate data rows marked as ignored. Both WP002 rows are included in the combined collar table; note that the second WP002 row (id 3) is marked as ignored:

The same is true for the combined lithology table, where the duplicate rows for the WP002 borehole are marked as ignored:

This example shows how special value handling rules in the source table are used in creating the combined table. The source table has negative values in the first three rows and the special values handling rules specify that non-positive values are replaced with 0.0 for the S_pct column. In the combined table, the Replace With value of 0.0 is used:

When the rule for the source table is changed so that non-positive values are omitted, the S_pct column is blank for the three rows in the combined table:

The process for creating a combined drilling data set involves creating an initial set of base tables from existing interval values, downhole points, downhole structural data or screens data:

The options available will depend on the drilling data that is already in the project.

Working with a screens table is only available with the Hydrogeology extension. See The Screens Table in the Importing Drilling Data topic for more information.

Once you have created the initial combined data set, you can add edit it and add more tables.

The rest of this topic describes the steps involved in building a combined drilling data set. It is divided into:

Creating the Base Tables
Changing Table Priority
Editing a Combined Drilling Data Set
Adding More Tables

Options for exporting a combined drilling data set are the same as those for other drilling data sets except that errors cannot be exported, as they should be corrected in the drilling data sets used to build the combined data set. See Exporting Drilling Data in the Drilling Data topic.

Creating the Base Tables

The first step in creating a combined drilling data set is to create the base tables, along with one of the following:

An interval table
A table of points values
A planar structural data table
A screens table

To start, right-click on the Borehole Data folder and select one of the New Combined Boreholes options.

In the window that appears, enter a name for the new drilling data set, then click OK.

Next select the tables you will use for the new table. Here the Interval Values option has been chosen and lithology tables from two data sets will be used:

You can only select one table from each drilling data set, but you can create additional tables once you have created the combined drilling data set. See Adding More Tables.

Click OK. In the New Combined Borehole Table window, the selected tables are displayed. The Combined Columns list shows the columns that will result:

All columns in the selected tables are automatically added to the Combined Columns list. If you wish to remove a column from the combined table, click on it in the Combined Columns list, then click the Remove button ():

If you do not wish to use a source data column in the combined table, click on it in the Combined Columns list, then click the Remove button ():

You can also:

Use the arrows in the Selected Tables list to change the priority of the tables. This is discussed further in Changing Table Priority.
Add more tables to the Selected Tables list. To do this, click the Select Tables button, then choose from those in the project.

Add more columns to the combined data set. Drag a column from the Available columns list into the Combined Columns list or click the Add button () to open the Select Columns window.

Rename a combined column. Double-click on it and enter the new name:

Once you have added the data columns you wish to include, set a Name for the new interval table, then click OK. The new combined drilling data set will be created and added to the project tree. Options for working with this combined data set are similar to those for working with imported drilling data sets.

Changing Table Priority

The priority of each table in the Combined Borehole Table window determines which information is used when there is duplicate information. For example, here the WP002 and WP003 table is higher in the list and so has higher priority than the WP001 and WP002 table:

Because the same holeid is used in each source table, one is marked as ignored in the combined data set.

Use the arrows to change the priority of selected tables:

Click OK to close the window and make the changes.

Editing a Combined Drilling Data Set

To edit a combined drilling data set, right-click on the a table in the data set and select Edit Combined Table. This opens the Edit Combined Borehole Table window, which is similar to the New Combined Borehole Table window. In this window, you can:

Change the priority of the source tables. Click on a table in the Selected Tables list and use the arrows to change its priority.
Add more tables to the Selected Tables list. To do this, click the Select Tables button, then choose from those in the project.
Add more columns to the combined data set. Drag a column from the Available columns list into the Combined Columns list or click the Add button () to open the Select Columns window.

If a table you wish to use is not in the Available columns list, click Cancel to go back to the Edit Combined Borehole Table and click the Select Tables button.

Rename a combined column. Double-click on it and enter the new name:

To remove a column from the combined table, click on it in the Combined Columns list, then click the Remove button ():

To remove a data source column from the combined table, click on it in the Combined Columns list, then click the Remove button ():

When you open the combined collar table or survey table to edit them, the options available are limited, as these tables are built up by adding other tables to the data set.

Adding More Tables

To add another table to the drilling data set, right-click on it and select one of the New Combined Table options:

Here the assay tables from the two source drilling data sets have been used to create a new combined assay table with three columns in the combined drilling data set: