Download - Lab_8_Joining and Relating
How to Join and Relate
Prof. Dr. Sajid Rashid Ahmad
Atiqa Ijaz Khan _ Demonstrator
Step by Step Procedure
• In the Table of Contents, right click on feature file (i.e. shapefile) > Join or Relate.
• Select any Join Type:• Join from attribute table (Default)
• Join from another spatial location
• Chose the field from the current layer on which layer will be joined.
• Chose table or layer.
• Chose the field from table on which table will be joined.
• Select any Join Options:• Keep all records
• Keep only matching records
• OK
Tuesday, March 3, 2015Institute of Geology, University of the Punjab
3
Tuesday, March 3, 2015Institute of Geology, University of the Punjab
6
Field for current layer
Target table
Field for target table
Join options
Validate, to check before proceed
NON-SPATIAL JOIN
Tuesday, March 3, 2015Institute of Geology, University of the Punjab
7
Validate the Join
Showing the warning from the table file, due to having round brackets () in the field name, that can cause
failure. But, it doesn’t gives any kind of error in joining.
Tuesday, March 3, 2015Institute of Geology, University of the Punjab
8
To Remove and Counter check the Join
or Relate
To access the Join:
Just click open the Attribute table
Tuesday, March 3, 2015Institute of Geology, University of the Punjab
9
To Counter Check from Layer Properties
Join Data Based on Spatial Location
Tuesday, March 3, 2015Institute of Geology, University of the Punjab
10
Step by Step Procedure
• In the Table of Contents, right click on feature file (i.e. shapefile) > Join or Relate.
• Select any Join Type:• Join from another spatial location
• Chose the layer that will be joined (Target Layer).• Point
• Line
• Polygon
• Chose the options available for the joining.
• Save it in a new layer, name it.
• OK
Tuesday, March 3, 2015Institute of Geology, University of the Punjab
11
Tuesday, March 3, 2015Institute of Geology, University of the Punjab
12
Choose the Target Layer
Choose the Options for join
Save and Name it as new layer
SPATIAL JOIN
Tuesday, March 3, 2015Institute of Geology, University of the Punjab
14
Field from the Input Layer
Select the table/layer to relate
Field from the Target layer
Name the relate
RELATE
Tuesday, March 3, 2015Institute of Geology, University of the Punjab
16
To access the Relate table
1. Open Attribute Table from TOC
2. Go to Options
3. Go to Related table and Click
4. It will list the Relate of that layer
5. Click to Open
Or
1. Select the Related Tables