Join Attributes - Create dynamic joins between tables

With this function you can transfer attributes of a source to a destination table or theme by joining them via data fields or spatially via the Shape field (the field attributes of the source are added to the destination table/theme between the records with matching data values or according to the spatial relationship of their features - read Hints to join attributes for more information).

In this dialog you can create joins between tables or themes in a comfortable and quick way (compared to the normal, quite complicated process in ArcView). You just have to select a source and a destination table and select a join field. You can also select several destination tables and create multiple joins in one step. All existing joins of the project are displayed, therefore you can analyze which tables are already joined via which fields. All joins are recorded in a log, thus by choosing two tables, the most likely join fields are proposed automatically.

Note: The log of the joins is lost if you uninstall the extension Arc4You Data. If you install the extension again, the log is empty and no former joins can't be reproduced automatically.

If the button isn't active, your settings were incorrect. Move the cursor over the button to see the error message:

When themes are joined spatially via the Shape field, it depends on the type of the source and destination theme how their features are related (read Hints to join attributes for more information):

Source

Destination

Spatial Join

Point

Point

nearest point

Point

Line

nearest point

Point

Polygon

incorrect combination

Line

Point

nearest line

Line

Line

line in which it is fully contained

Line

Polygon

incorrect combination

Polygon

Point

polygon in which the point is situated

Polygon

Line

polygon in which the line is fully contained

Polygon

Polygon

polygon in which it is fully contained