https://community.esri.com/t5/arcgis-pro-ideas/deterministic-one-to-first-joins-on-enterprise/idi-p/1600922 <P>It’s my understanding that one-to-first joins on enterprise geodatabase data are non-deterministic. Despite what the Add Join documentation says, the related record with the lowest OBJECTID is not used. Instead, an arbitrary related record is used; the related record can change without an apparent reason. That's problematic from a data analysis perspective.</P><P>Related: <A href="https://community.esri.com/t5/arcgis-pro-ideas/choose-if-join-will-be-one-to-first-or-one-to-many/idc-p/1597297/highlight/true#M34184" target="_self">Choose if join will be one-to-first or one-to-many</A></P><P>This idea is to make one-to-first joins be deterministic on enterprise geodatabase data.</P> Mon, 31 Mar 2025 23:10:43 GMT Bud 2025-03-31T23:10:43Z https://community.esri.com/t5/arcgis-pro-ideas/deterministic-one-to-first-joins-on-enterprise/idi-p/1600922 <P>It’s my understanding that one-to-first joins on enterprise geodatabase data are non-deterministic. Despite what the Add Join documentation says, the related record with the lowest OBJECTID is not used. Instead, an arbitrary related record is used; the related record can change without an apparent reason. That's problematic from a data analysis perspective.</P><P>Related: <A href="https://community.esri.com/t5/arcgis-pro-ideas/choose-if-join-will-be-one-to-first-or-one-to-many/idc-p/1597297/highlight/true#M34184" target="_self">Choose if join will be one-to-first or one-to-many</A></P><P>This idea is to make one-to-first joins be deterministic on enterprise geodatabase data.</P> Mon, 31 Mar 2025 23:10:43 GMT https://community.esri.com/t5/arcgis-pro-ideas/deterministic-one-to-first-joins-on-enterprise/idi-p/1600922 Bud 2025-03-31T23:10:43Z