topic Re: Join table view to feature class - not working in Data Management Questions

Join table view to feature class - not working

BenVan_Kesteren1 — Wed, 04 Feb 2015 23:03:18 GMT

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.

Re: Join table view to feature class - not working

KishorGhatage — Thu, 05 Feb 2015 05:34:43 GMT

35151 - 000732: Dataset does not exist or is not supported

Re: Join table view to feature class - not working

NeilAyres — Thu, 05 Feb 2015 06:33:26 GMT

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.

Re: Join table view to feature class - not working

JayantaPoddar — Thu, 05 Feb 2015 06:42:18 GMT

Hi Ben,

Try Using Add Join (Data Management) instead of Add Field, in the model.

ArcGIS Help 10.1

Thanks,

Jay

Re: Join table view to feature class - not working

ZacharyOrdo1 — Mon, 18 Sep 2017 22:00:45 GMT

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? - Geographic Information Sys…
User input paths will have to be converted to full paths using arcpy.describe() if you intend to use them with other variables.