Hi Kory, I've already gotten the trial of ArcGIS through my university, so I have ArcMap 10.6 installed on my computer. But when I tried to do the geocoding for these data the error messages I got made it seem like I don't have access to the ArcGis Online subscription, which is why I was trying to access that via a free trial. I did end up getting a .shp of the zip code borders and headed down the path of joining or relating that to my data points. However, I do have a 1:M situation so I'm not sure how to proceed. Ultimately I want to map each of my data points in ArcMap. I ran a relate between the zip code .shp and my data points, but my data file doesn't have an ObjectID field so when I open the .shp attribute table and click on "Related Tables" up top, the relate is greyed out and I can't click it. I found another post about the same issue (https://community.esri.com/thread/103332 ) but I'm not sure how to do what the answer to this post says to do. Do you have any advice on how I can proceed with this? I just want to map my data points, which are stored as zip codes for each case number in an Excel file (so not a geodatabase) as points on a shape file of the state. Thanks!
... View more