topic Join GUID field to shapefile via arcpy in Python Questions https://community.esri.com/t5/python-questions/join-guid-field-to-shapefile-via-arcpy/m-p/318491#M24745 <HTML><HEAD></HEAD><BODY><P>So, I understand that GUID fields aren't supported by shapefiles, and when you do a join manually in ArcMap (right click layer in TOC &gt; join), it converts the GUID field to a string to join a table with a GUID to a shapefile. I figured it would do the same thing in arcpy as it does in ArcMap when using JoinField_management, but instead the tool fails. Is there any way to have that GUID field convert to string so I can join it with my shapefile? The only way I can think to do it is to copy the SDE database and change the GUID field to string field before joining it with my shapefile in arcpy, but I really want to avoid doing that as it isn't practical.</P></BODY></HTML> Wed, 18 Oct 2017 12:04:59 GMT MKF62 2017-10-18T12:04:59Z Join GUID field to shapefile via arcpy https://community.esri.com/t5/python-questions/join-guid-field-to-shapefile-via-arcpy/m-p/318491#M24745 <HTML><HEAD></HEAD><BODY><P>So, I understand that GUID fields aren't supported by shapefiles, and when you do a join manually in ArcMap (right click layer in TOC &gt; join), it converts the GUID field to a string to join a table with a GUID to a shapefile. I figured it would do the same thing in arcpy as it does in ArcMap when using JoinField_management, but instead the tool fails. Is there any way to have that GUID field convert to string so I can join it with my shapefile? The only way I can think to do it is to copy the SDE database and change the GUID field to string field before joining it with my shapefile in arcpy, but I really want to avoid doing that as it isn't practical.</P></BODY></HTML> Wed, 18 Oct 2017 12:04:59 GMT https://community.esri.com/t5/python-questions/join-guid-field-to-shapefile-via-arcpy/m-p/318491#M24745 MKF62 2017-10-18T12:04:59Z Re: Join GUID field to shapefile via arcpy https://community.esri.com/t5/python-questions/join-guid-field-to-shapefile-via-arcpy/m-p/318492#M24746 <HTML><HEAD></HEAD><BODY><P>you would have to include add_field management and calculate_field management into your script to basically do what you know you can do manually before doing the join</P></BODY></HTML> Wed, 18 Oct 2017 12:19:24 GMT https://community.esri.com/t5/python-questions/join-guid-field-to-shapefile-via-arcpy/m-p/318492#M24746 DanPatterson_Retired 2017-10-18T12:19:24Z Re: Join GUID field to shapefile via arcpy https://community.esri.com/t5/python-questions/join-guid-field-to-shapefile-via-arcpy/m-p/318493#M24747 <HTML><HEAD></HEAD><BODY><P>Thanks, although less stream-lined than I'd like, that'll work and is probably the best way.</P></BODY></HTML> Wed, 18 Oct 2017 12:55:49 GMT https://community.esri.com/t5/python-questions/join-guid-field-to-shapefile-via-arcpy/m-p/318493#M24747 MKF62 2017-10-18T12:55:49Z