How to join a .CSV to a .SHP to have a spatial location

Question

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

MehdiPira1 · Answer

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/

DanPatterson_Retired · Answer

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