idea Disallow 1:M join layers as GP inputs instead of producing unexpected results in ArcGIS Pro Ideas

Disallow 1:M join layers as GP inputs instead of producing unexpected results

Bud — Wed, 22 May 2024 15:14:16 GMT

The Add Join docs say:

Because many geoprocessing tools do not support data with duplicate object IDs and processing such data can produce unexpected results, it is recommended that you first copy the joined layer to a new feature class using the Export Features tool. Then use the new feature class as input to other geoprocessing tools.

If 1:M join layers are not an acceptable input, then an error should be thrown rather than accepting invalid data and producing incorrect results.

Can geoprocessing tools be enhanced so that they disallow 1:M join layers, where applicable?

Re: Disallow 1:M join layers as GP inputs instead of producing unexpected results - Status changed to: Needs Clarification

DrewFlater — Wed, 22 May 2024 22:48:21 GMT

@Bud the condition with duplicate OIDs caused by a 1:M join cannot be known until the data is completely read, so this is not possible to "disallow" such layers from being used as input. We have found that some tools error under this condition, while others use the first record in the set of duplicate OIDs, while others do other things. All of these specific behaviors based on different tool implementations cannot be explained in full detail in a documentation topic like you highlighted from Add Join, thus the generic "can produce unexpected results".

We have internal development enhancement issues logged to support dynamically generating unique OIDs for the case of 1:M joins, which will work around any limitations there may be for geoprocessing tool algorithms that require unique OIDs. This idea in the current state is not actionable, but if you want to change the idea or enter a new idea for some tools that you have used to support 1:M join layers as input without duplicating the OIDs, we can make a match to our internal development issue.

Re: Disallow 1:M join layers as GP inputs instead of producing unexpected results

RTPL_AU — Mon, 15 Jul 2024 01:06:15 GMT

@Bud Rephrase your idea as: Support dynamically generating unique OIDs for the case of 1:M joins, to work around any limitations there may be for geoprocessing tool algorithms that require unique OIDs. 🤣

Re: Disallow 1:M join layers as GP inputs instead of producing unexpected results

Bud — Mon, 15 Jul 2024 04:38:01 GMT

Add Join — Pseudo-ObjectID (row number) as unique ID field for 1:M join

Re: Disallow 1:M join layers as GP inputs instead of producing unexpected results - Status changed to: Closed

DrewFlater — Fri, 08 Aug 2025 22:01:58 GMT

There is no mechanism to disallow 1:m joined data. This enhancement idea is being considered to dynamically assign unique ObjectIDs when performing a 1:m join, so the result can be used as input to more/most geoprocessing tools.

https://community.esri.com/t5/arcgis-pro-ideas/add-join-pseudo-objectid-row-number-as-unique-id/idi-p/1494563