Calculate Field Based on Overlapping Polygons

[MadelynSimpson]

Hey, I'm gonna explain this as best as I can. I need to create a spreadsheet that lists all of the zip codes that overlap with our members and lists the member that the zip code overlaps with. The pink is the zip codes, and the brown outline is our member boundaries. How do I calculate the field in the zip code attribute table so it lists the members that overlap it? I don't need to combine fields, I just need to calculate a field or create a new field that lists the overlapped member. I hope that makes sense.

[DanPatterson]

Have you ruled out general overlay operations like the 

Spatial Join (Analysis)—ArcGIS Pro | Documentation

in the Overlay toolset?

[MadelynSimpson]

So unfortunately, I don't think a join will work. I don't have matching fields in the two attribute tables. So unfortunately, there's nothing to join between the two. I'm hoping there's some kind of tool or a python script I can run that will list the member(s) that overlap with the corresponding zipcode(s)

[DanPatterson]

the spatial join is based on geometry not on matching attributes

[Pukawai]

I don't think you can get a spatial join to give you the result you want since that is normally only useful between points and polygons. It and be done with python if do a union between your two layers, concatenate the zip codes in each resulting polygon that has the same member ID, and then dissolve on member ID to get back your original member polygons.

[DanPatterson]

perhaps you misread

Spatial joins by feature type—ArcGIS Pro | Documentation

Add Spatial Join (Data Management)—ArcGIS Pro | Documentation