Join problems in ArcView Desktop
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.