Database>dBMerge enables merging dBase files based on common key fields.


This section reviews use of the dBMerge operation to integrate subject matter data into a shapefile.  The dBase file gz_2010_us_050_00_500k.dbf described in the dBCreate section contains no demographic subject matter data.  While a map can be made of the U.S. by county using the shapefile gz_2010_us_050_00_500k.shp, thematic pattern maps cannot be created before first integrating data with the shapefile.


This section illustrates steps to integrate demographic subject matter data from the U.S. by county Census 2010 Demographic Profile Summary File (DPSF) into the gz_2010_us_050_00_500k.dbf.



Levels 2, 3

All features overview



Main menu Database>dBMerge


Related Information



Illustrative steps


Setup steps ...

Expand to c:\cvxe\1\dpsf2010mstr_050.dbf
Expand to c:\cvxe\1


Verify the files c:\cvxe\1\GZ_2010_US_050_00_500K_copy.DBF and c:\cvxe\1\dpsf2010mstr_050.dbf exist on your computer.


Start Database>dBmerge


Use Open Source File 1 to open c:\cvxe\1\GZ_2010_US_050_00_500K_copy.DBF (the dbf associated with the shapefile)

Use Open Source File 2 to open c:\cvxe\1\dpsf2010mstr_050.dbf


The dBMerge form now appears as shown below.




Click the Create button; the Source Fie 1 and Source File2 fields populate:



Change the Key1 and Key2 files to state+county as shown below.

Select the 6 fields in Source File 1 and click Move Selected under Source File 1.

View now appears as shown below,



Select fields in Source File 2 starting at D0010001 though last field and click Move Selected under Source File 2.

Click Merge button and merge starts.  Wait until merge complete and allow overwrite.





ProximityOne -- resources to create and apply insights © ProximityOne