
0
Data Merge
Guys I'm trying to do a Data Merge from a DH_Lithology_ file to a DH Assay table.
The Lith file has different From To compared to the sample file which is 1m intervaIs.
I need to get the Lith code value populated into the Sample Files corresponding interval ie if the Lith from to is 5.1 - 15 m I need the Lith code from there to populate the sample table form 5m all the way to 15m with the Lith value.
Can this be done as im not having much luck with the various options.
Customer support service by UserEcho
better create a overlap table to map these 2 intervals like :
Column | Datatype | Computed value
------------------------------------------
PROJECT | nvarchar(16) |
SITE_ID | nvarchar(50) |
SAMPLE_ID | nvarchar(50) |
Depth_From | decimal |
Depth_To | decimal |
GeolFrom | decimal |
GeolTo | decimal |
RELOGGED | int |
fill the data by daily job.
Have you tried:
Drillhole\Composite\Interval
Source A = Assay
Source B= Lith
Intervals From A (FULL)
Character Fields DOMINANT
Hi Scott, Drillhole Interval Compositing will do what you want as described above. You might find, Drillhole, Data, Merge Drillholes useful too. This has the advantage of Merging only select fields so it keeps your Assay file neater.
Source file: Lithology File
Target: Assay file
Merge fields: Any fields you want to merge
Match: Longest