topic Re: Many to one join in ArcGIS Pro Questions

Many to one join

TiffanyFalk1 — Fri, 30 Oct 2020 15:41:42 GMT

Any thoughts on how to join a data table to polygons in ArcGIS Pro where they can be assigned to multiple polygons? If you picture each of the states in the US and you want to join a table of all the birds in the US. There are birds that can be present in multiple states. How should I set up the table to get the join to work? Or should I use a relate? Here is a screenshot of the table and polygon shape. Thanks!

Re: Many to one join

JoeBorgione — Fri, 30 Oct 2020 16:10:17 GMT

I shy away from joins when the word 'many' is used. I prefer a relate or a relationship class.

Re: Many to one join

TiffanyFalk1 — Fri, 30 Oct 2020 17:41:06 GMT

Thanks Joe,

I know I'm not setting the relate up properly, any thoughts on how to get it to work? Can I use the K Column (Labeled "Zone" in the top image to relate it to the polygons? Does it need a particular format? Thanks.

Re: Many to one join

JoeBorgione — Fri, 30 Oct 2020 18:05:58 GMT

When you use a given field for the 'key' field in a relate, the values in both table need to be consistent. I don't see the same values in K anywhere in the polygon fields. You can certainly set a relate between these two, but given the view of them, they don't have any common values between them in the respective Zone fields.