I am trying to associate data (.csv file) with a spatial location (.shp file). Both attribute tables include a zip code which I am trying to join them by. In addition, the are multiple rows of data associated with a zip code. How do I apply the spatial location of the zip code to each entry? Thanks
Joining (.shp): To the data (.csv): So that each .shp 1, 2, 3 apply to each entry applicable
1 3 data
2 2 data
3 3 data
1 data
2 data
convert the csv to a file geodatabase table, then check the contents of the joining field to make sure they are indeed common (numbers are right justified, text left, but numbers can look like text if they aren't translated properly.
A many to one is a relate, not a join.
Do a screen grab of the two tables when you get things in order for the join
Dan is right. One to Many relationship is a relate not a join. Here are some useful links that explains better:
http://desktop.arcgis.com/en/arcmap/10.3/manage-data/tables/about-joining-and-relating-tables.htm
https://gisgeography.com/relate-vs-join-attribute-tables-arcgis/