Hi, I have two files that I need to join. I have a geodatabase file that has all the zip codes, Name of the state, the Object ID and other information.. I also have a CSV file that has the alumni for my school and their zip code. I am trying to join the two based on the Alumni Zip code. When I do that, not all the zip codes match.Can someone show me how to do that please? I have the documents posted here if you want to view them.
You uploaded a layer (*.lyr) file and a csv file. The layer file is only a pointer to the data and does not contain your actual data. Could you upload your data as a layer package or could you give an example of a zip code that isn't matching? What are the types of the fields you're trying to match and are you sure that the values match exactly. For example, if the zip codes are being handles as strings "92373" is not equal to "92373 " (i.e. number with a space behind it).
If the contents of a field are
As Freddie points out, you have to consider leading and/or trailing spaces with text.
If one table's contents look the same as the others but the justification differs, then you have to convert to either a numeric or text standard
If just a few aren't matching, and the field is text, check for case as well as leading/trailing spaces.
I the above applies, but the values are numeric comparing floats is tricky ... but I doubt that this is your case.
Are you still unable to upload your data to geonet? If so, let me know and I can provide you with credentials to a secure ftp server where you can upload the data and I can take a quick look at it. Prior to uploading the data I'll need you to remove any confidential information.