topic Issues with joining a table to a feature class in Geoprocessing Questions

Issues with joining a table to a feature class

SaraHedrick1 — Thu, 11 Apr 2024 19:50:32 GMT

I have a table with a 'Region' field that a want to join to a Regions feature class. The regions feature class has one value for each region. I would like to join the regions table to the feature class so that there is a polygon for each associated region in the join. Since of values in the table could change, I need to be able to do this within the join. Has anyone had any luck doing something like this? I'd tried a few different things, but none provide the desired results.

To clarify, if the table has three records for the Alaska region and I'd like to join it so that there is an Alaska polygon is associated with all three records.

Re: Issues with joining a table to a feature class

Dale_Honeycutt — Thu, 25 Apr 2024 23:18:22 GMT

Make Query Table will do the trick here. It's been a loooong time since I've used it, so if you need help with the input parameter values, I'll need to set up a test case.

Re: Issues with joining a table to a feature class

DuncanHornby — Thu, 02 May 2024 13:50:59 GMT

To add to Dales answer you probably want to export the data to make it permanent otherwise it only exists as temporary layer in the map.