Trouble Joining a Table to Parcels

819
3
09-17-2014 09:22 AM
DaveMartin1
New Contributor

Hi,

I'm attempting to Join a Table of data to property parcels.  I have a Parcel ID Number (PIN) that is common to both the parcel and the parcel data. After joining on the PIN fields, I open the Attribute Table for the Parcels.  Ordinarily I would see field names that are a combination of the fields in the two different files.  This isn't showing up. The data is not joining.

The joining fields are both string (text) and the same length (14 characters).  Also, there are no 'spaces' in the field names. 

I'm stumped.  Any suggestions?

Dave

0 Kudos
3 Replies
JorgeOrellana
Occasional Contributor II

before performing your join and you select the Validate Join button, does it say return any message or warnings?

0 Kudos
DanPatterson_Retired
MVP Emeritus

The link which lists the potential errors is given here

0 Kudos
RichardFairhurst
MVP Honored Contributor

When you say the the combination of the fields in the two different tables is not showing up, do you mean that only the fields of the original layer that existed before the join are in the table view, or do you mean that you see the field names of the joined table, but all of the records have Null values in those fields?  If you see the joined table fields, but all of the records have Null values in those fields, be sure that the format of the actual values that are supposed to be joined are identical on both data sources, including the presence or absence of leading or trailing white space characters, capitalization, dashes/special characters, etc.

If your table is an Excel Spreadsheet you should convert it to a real table with ObjectIDs.  ObjectIDs in a data source are required to get the full range of behaviors that are possible when using a join.  Creating joins with a data source that has no ObhectIDs, like and Excel Spreadsheet, result in huge limitations on what behaviors are supported.

0 Kudos