topic Re: Trouble Joining a Table to Parcels in Data Management Questions

Trouble Joining a Table to Parcels

DaveMartin1 — Wed, 17 Sep 2014 16:22:04 GMT

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

Re: Trouble Joining a Table to Parcels

JorgeOrellana — Wed, 17 Sep 2014 16:42:00 GMT

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

Re: Trouble Joining a Table to Parcels

DanPatterson_Retired — Wed, 17 Sep 2014 17:22:59 GMT

The link which lists the potential errors is given here

Re: Trouble Joining a Table to Parcels

RichardFairhurst — Wed, 17 Sep 2014 18:46:47 GMT

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.