Hi All,
I have a feature class (Sewer Mains) in my SDE which has a field ASSETID. I have another database (financial management) that I have linked to my SDE by way of a view. So essentially in my SDE I have a table which as far as I can tell acts exactly like a table that resides within the SDE (I could be mistaken!)
This is a screenshot of the fields within my View Table... note AssetID_CQ is the primary key which I would like to join my feature class in order to do further jobs with.
This is a simple model I have just created, in which I would like a new feature class be created based on the AssetID Join... But I am getting an error, I have screen shotted the error also, does anyone know how to fix this? I understand my VIEW does not have an ObjectID, but thats because it is a view, not a table. Is there a way around this error?
Thanks for your time.
It is also possible, if you have any custom code in your model, that this will fix it...
arcpy - Getting full path of layer selected in drop-down box for ArcGIS Python script tool? - Geogra...
User input paths will have to be converted to full paths using arcpy.describe() if you intend to use them with other variables.
Have you tried to do this simply in ArcMap rather than a model.
The view join doesn't seem to be active at all. It's not coloured blue.
Hi Ben,
Try Using Add Join (Data Management) instead of Add Field, in the model.
Thanks,
Jay