How to merge your targets back into your survey database

Objective:

I would like to add a target channel into my survey database.

Resolution:

Before starting, make sure you have displayed all the decimals in the X and Y channels of your target database so that the full number gets exported to the XYZ file. 

1. Select your Target database and from the Database menu click export and select Geosoft XYZ.
2. Enter a name for the XYZ file and click Template.
3. Check the box for Include dummies and clear all other checked boxes.
4. From the list of database channels move your X, Y, Target ID, and any other channel you wish to merge with your survey database from the left to the right.
5. Click Ok twice.
6. Open the XYZ in a text editor outside of Oasis montaj.
7.  Add the following header to your XYZ file and resave the file as a *.tbl file
   
   /= X:real:I
   /= Y:real:I
   /= Target_ID:real
   /= Amplitude:real
   /
   / X  Y  Target_ID Amplitude
   
   
8. In Oasis montaj select your survey database and go to the Database Tools menu and click Database Utilities and select 2 Channel Lookup.
   
   Select your lookup table
   Primary index = select your X channel from survey database
   Table primary Index field = X
   Secondary index channel = select your Y channel from survey database
   Table secondary index field = Y
   Output channel = Target_ID
   Table output field = Target_ID
   Interpolation method = exact
   OK
   
   
9. Channel may be hidden in the Survey database, click on an empty channel header and click list then click on your new channel from the list of hidden channels.
10. Repeat steps 8 – 10 for any other channels you wish to merge ie. Amplitude

Notes:

This workflow will only work if your targets were picked from the survey database and not from a grid.  The X and Y used as a reference need to be exact.  The “nearest” option does not work for 2 channel look up tables, the primary reference always has to be exact and then the secondary reference will use “nearest”, but not for both.