topic add table to polygon layer in ArcGIS Pro Questions

add table to polygon layer

TaleSkrove — Fri, 17 Jan 2020 14:47:13 GMT

Hi,

I've got a table with 3000 registrations that I want to join to a layer with 100 polygons so that the output is 3000 polygons (30 separate registrations per polygon). The table contains a column with unique polygon numbers. Can't figure this one out, but it seems like something that should be quite easy in ArcGIS Pro. Hope someone can help!

Re: add table to polygon layer

KellyKoenig — Fri, 17 Jan 2020 16:32:21 GMT

If you have an Advanced license, you can use the Join Features tool and select "Join one to many" in the join operation section.

Otherwise, try the Make Query Table tool. Be sure to include the shape field from your polygon layer in the "Fields" section to create a feature layer output instead of a table.

The result of the Make Query Table tool will be temporary, so export a copy of it before exiting your project to save it permanently.

Re: add table to polygon layer

TaleSkrove — Mon, 20 Jan 2020 10:35:23 GMT

Thank you for your reply. The “Make Query Table” tool seems to be the correct one, but I end up with the table of 3000 rows adding to each of the 100 polygons in the shape layer, instead of just the 30 with the same key. Any further suggestions?

Re: add table to polygon layer

TaleSkrove — Mon, 20 Jan 2020 13:17:23 GMT

Update: after a system update I got access to the Join Feature tool and it worked perfectly! Thank you for your help.