Page History

...

1. Click Tabular.zip above to download the tutorial data.
2. Open the Downloads folder.
3. Right-click Projections.zip and select Extract All....
4. In the 'Extract Compressed (Zipped) Folders' window, accept the default location into the Downloads folder and click Extract.
5. Drag the unzipped Tabular folder onto your Desktop.
6. Close all windows.

...

Notice the four new fields added to the end of the DowntownParcels attribute table showing the land use for every parcel. Because you want to symbolize the parcels using the generalized land use categories, you will now also join the LandUseCode_LookupTable table using the land use code as the common field.

...

.

1. In the Contents pane, right-click the DowntownParcels layer and selectJoins and Relates > Add Join.
2. For ‘Input Join Field’, use the drop-down menu to select the Land.LAND_USE_C field.

Notice that when a previous join is still in place, the field names are appended with the name of the layer or table from which they are derived.

1. For ‘Join Table’, use the drop-down menu to select the LandUseCode_LookupTable table.
2. For ‘Output Join Field’,

...

1. use the drop-down menu to select the LANDUSE_CODE

...

1. .
2. Click Run.
3. If necessary, scroll to the far right in the DowntownParcels attribute table.

Notice that all of the values in the six newly joined fields are null. This is an indication that something is wrong with the join. The two most common reasons for a join not to work are either the values in the two fields in the two separate fields used for the common join are not identical or the join table itself is not formatted correctly, which should only occur if the outside table is brought in from another format, such as Excel or a CSV. In this case, the stand-alone join table was already in a file geodatabase, so there should not be a problem with the overall table formatting. Instead, you will look into the actual values stored in the land use code field

...

.

Troubleshooting Joins

You will now examine the two tables more closely to determine why the desired join field did not show up in the’ Join Data’ pane.

...