Solved! Go to Solution.
Hi Vincent
I assume you have a feature class ( 1 feature) to join to a table ( Many rows) in an enterprise geodatabase? You can use a database view with a right join to result in 1 feature (overlapping) linked to each row from the table.
If its between two tables, you could also try Joining attributes in one table to another—ArcMap | Documentation (arcgis.com). This page might also help Essentials of joining tables—ArcMap | Documentation (arcgis.com)
Regard Ed
Hello Vincent
Ok, I see the issue now. Object ids are unique in the underlying enterprise geodatabase artifact but not in the view. Depending on your relational database management system (Microsoft SQL, Oracle etc), you could try, for example, Create View AS <viewname>, Select ROWNUMBER() As ID, or NEWID() As 'id' ? This adds an artificial identifier for row number in the view representation and does not represent a unique identifier for rows from the underlying source tables. My understanding is that this kind of identifier cannot be used as a primary key or be in a foreign key relationship between this View and other artifacts. Worth a try.
If that doesn't work, then the only other alternative is to create the desired artifact before the linear regression analysis can occur. Use Add Join geoprocessing tool on two layers and then use the Copy Features or Feature Class to Feature Class tool to export into a new artifact. The new artifact would then have unique object ids for each row. Use a Model (Model Builder) to script this workflow to run manually as required or schedule it to run at a time and frequency that suits.
Add Join (Data Management)—ArcGIS Pro | Documentation
Ed
Hi Vincent
I assume you have a feature class ( 1 feature) to join to a table ( Many rows) in an enterprise geodatabase? You can use a database view with a right join to result in 1 feature (overlapping) linked to each row from the table.
If its between two tables, you could also try Joining attributes in one table to another—ArcMap | Documentation (arcgis.com). This page might also help Essentials of joining tables—ArcMap | Documentation (arcgis.com)
Regard Ed
Thank you Edwardo Fernandez for your response.
Generalized Linear Regression (GLR)
=====================
=====================
(Error) Messages
Start Time: Friday, August 20, 2021 8:21:21 PM
WARNING 001605: Distances for Geographic Coordinates (degrees, minutes, seconds) are analyzed using Chordal Distances in meters.
ERROR 000644: Duplicate IDs found in OBJECTID.
ERROR 000643: Invalid unique ID field.
Failed to execute (GeneralizedLinearRegression).
Failed at Friday, August 20, 2021 8:21:38 PM (Elapsed Time: 16.86 seconds)
Hello Vincent
Ok, I see the issue now. Object ids are unique in the underlying enterprise geodatabase artifact but not in the view. Depending on your relational database management system (Microsoft SQL, Oracle etc), you could try, for example, Create View AS <viewname>, Select ROWNUMBER() As ID, or NEWID() As 'id' ? This adds an artificial identifier for row number in the view representation and does not represent a unique identifier for rows from the underlying source tables. My understanding is that this kind of identifier cannot be used as a primary key or be in a foreign key relationship between this View and other artifacts. Worth a try.
If that doesn't work, then the only other alternative is to create the desired artifact before the linear regression analysis can occur. Use Add Join geoprocessing tool on two layers and then use the Copy Features or Feature Class to Feature Class tool to export into a new artifact. The new artifact would then have unique object ids for each row. Use a Model (Model Builder) to script this workflow to run manually as required or schedule it to run at a time and frequency that suits.
Add Join (Data Management)—ArcGIS Pro | Documentation
Ed
Thank you so much EduardoFernandez. I used copy features and it worked out for me.