topic Join AGOL hosted feature layer to feature class in Python Questions https://community.esri.com/t5/python-questions/join-agol-hosted-feature-layer-to-feature-class/m-p/123222#M9570 <HTML><HEAD></HEAD><BODY><P>In attempting to join a feature class to a hosted feature layer to determine if there are features that exist in the feature class and not in the hosted feature layer (see code below), I get the following error.</P><P>ERROR 000732: Join Table: Dataset fl does not exist or is not supported<BR />Failed to execute (AddJoin).</P><P></P><P>How can I join a hosted feature layer to a feature class?</P><P></P><P>publishedWebLayer = r"https://services1.arcgis.com/mapid/ArcGIS/rest/services/FeatureServer/1"<BR />mygis = arcgis.gis.GIS(r"https://maps.arcgis.com", "usr", "pw")<BR />fl = arcgis.features.FeatureLayer(publishedWebLayer, mygis)<BR />FC = r"C:\GIS\Data.gdb\BRW3"</P><P>arcpy.MakeFeatureLayer_management(FC, "fcView")<BR />joinField = "UID"<BR />arcpy.AddJoin_management ("fcView", joinField, "fl", joinField, "KEEP_ALL")<BR />arcpy.SelectLayerByAttribute_management("fcView","NEW_SELECTION",'"Incidents.OBJECTID" IS NULL')</P></BODY></HTML> Sun, 08 Sep 2019 18:31:38 GMT EdwardGlover1 2019-09-08T18:31:38Z Join AGOL hosted feature layer to feature class https://community.esri.com/t5/python-questions/join-agol-hosted-feature-layer-to-feature-class/m-p/123222#M9570 <HTML><HEAD></HEAD><BODY><P>In attempting to join a feature class to a hosted feature layer to determine if there are features that exist in the feature class and not in the hosted feature layer (see code below), I get the following error.</P><P>ERROR 000732: Join Table: Dataset fl does not exist or is not supported<BR />Failed to execute (AddJoin).</P><P></P><P>How can I join a hosted feature layer to a feature class?</P><P></P><P>publishedWebLayer = r"https://services1.arcgis.com/mapid/ArcGIS/rest/services/FeatureServer/1"<BR />mygis = arcgis.gis.GIS(r"https://maps.arcgis.com", "usr", "pw")<BR />fl = arcgis.features.FeatureLayer(publishedWebLayer, mygis)<BR />FC = r"C:\GIS\Data.gdb\BRW3"</P><P>arcpy.MakeFeatureLayer_management(FC, "fcView")<BR />joinField = "UID"<BR />arcpy.AddJoin_management ("fcView", joinField, "fl", joinField, "KEEP_ALL")<BR />arcpy.SelectLayerByAttribute_management("fcView","NEW_SELECTION",'"Incidents.OBJECTID" IS NULL')</P></BODY></HTML> Sun, 08 Sep 2019 18:31:38 GMT https://community.esri.com/t5/python-questions/join-agol-hosted-feature-layer-to-feature-class/m-p/123222#M9570 EdwardGlover1 2019-09-08T18:31:38Z