Ask A Cartographer

Join problems in ArcView Desktop

December 31 2009 | 0 comments
Categories: Map Data

I am having difficulty with what should be a straighforward join. Zip layer has zip as 5 character string. I am trying to join with Excel file that has zip as string. After join all the variables from Excel file are null. On properties of zip polygon, zip is 5 character string. On properties of Excel file, zip is 255 char string - I assume this is the problem but cannot get the properties to change - any suggestions?

Mapping Center Answer:

Frequently when dealing with Joins on string fields, the issue is the presense of trailing spaces.  Try calculating each field using Trim(<fieldname>).

If you would like to post a comment, please login.

Contact Us | Legal | Privacy |