AnsweredAssumed Answered

Join table view to feature class - not working

Question asked by ben_vk on Feb 4, 2015
Latest reply on Sep 18, 2017 by ordoinc

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.

2015-02-05_09-39-55_View Properties.jpg

 

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?

 

2015-02-05_09-39-11_Model.jpg

 

Thanks for your time.

Outcomes