topic Re: Steps in Joining Objects to Textual Data using Python in Python Questions https://community.esri.com/t5/python-questions/steps-in-joining-objects-to-textual-data-using/m-p/369064#M29108 <HTML><HEAD></HEAD><BODY><P><A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//00s500000033000000">querying data</A></P><P><A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//00170000006r000000">make query table</A></P><P><A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//001700000064000000">joins</A></P><P><A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//001700000035000000">Copy features</A></P><P>Amongst many other links...it is all in the help files, once you know the terms</P></BODY></HTML> Tue, 09 Sep 2014 07:43:42 GMT DanPatterson_Retired 2014-09-09T07:43:42Z Steps in Joining Objects to Textual Data using Python https://community.esri.com/t5/python-questions/steps-in-joining-objects-to-textual-data-using/m-p/369063#M29107 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I want to write a python script which :</P><P></P><P>1. fetch textual data from a table in a SQL database and create a local table (.dbf?) called TABLE A</P><P>2. join this textual data (TABLE A) to an existing .shp file (objects) using a unique ID and output this data into a new .shp.</P><P></P><P>I am a complete novice in python but just need a push in the right direction (commands &amp; summary of steps) and I should be able to piece it all together.</P><P></P><P>Many thanks,</P><P>Tim</P></BODY></HTML> Tue, 09 Sep 2014 07:36:43 GMT https://community.esri.com/t5/python-questions/steps-in-joining-objects-to-textual-data-using/m-p/369063#M29107 timdunlevie 2014-09-09T07:36:43Z Re: Steps in Joining Objects to Textual Data using Python https://community.esri.com/t5/python-questions/steps-in-joining-objects-to-textual-data-using/m-p/369064#M29108 <HTML><HEAD></HEAD><BODY><P><A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//00s500000033000000">querying data</A></P><P><A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//00170000006r000000">make query table</A></P><P><A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//001700000064000000">joins</A></P><P><A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//001700000035000000">Copy features</A></P><P>Amongst many other links...it is all in the help files, once you know the terms</P></BODY></HTML> Tue, 09 Sep 2014 07:43:42 GMT https://community.esri.com/t5/python-questions/steps-in-joining-objects-to-textual-data-using/m-p/369064#M29108 DanPatterson_Retired 2014-09-09T07:43:42Z