topic Manipulating field names on join in Python Questions https://community.esri.com/t5/python-questions/manipulating-field-names-on-join/m-p/57157#M4529 <HTML><HEAD></HEAD><BODY><SPAN>I have a shapefile that I want to programatically join with 12 other tables, retaining exactly 2 fields from each of the join tables.&nbsp; </SPAN><BR /><BR /><SPAN>These 12 other tables are all in the same gdb as one another, and while their names differ, the unique part of each name is at the end (TABLE_000001, TABLE_000002,..., TABLE_000012), so that when I join them with arcpy.AddJoin_management, the fieldnames are truncated into something indecipherable when I export to a new table.</SPAN><BR /><BR /><SPAN>Since I cannot add fields to a joined table, my idea of creating new fields with the names I want after each join does not work.&nbsp; Any idea how I can do this join and retain meaningful field names?</SPAN></BODY></HTML> Mon, 07 Apr 2014 18:54:20 GMT JamesHook 2014-04-07T18:54:20Z Manipulating field names on join https://community.esri.com/t5/python-questions/manipulating-field-names-on-join/m-p/57157#M4529 <HTML><HEAD></HEAD><BODY><SPAN>I have a shapefile that I want to programatically join with 12 other tables, retaining exactly 2 fields from each of the join tables.&nbsp; </SPAN><BR /><BR /><SPAN>These 12 other tables are all in the same gdb as one another, and while their names differ, the unique part of each name is at the end (TABLE_000001, TABLE_000002,..., TABLE_000012), so that when I join them with arcpy.AddJoin_management, the fieldnames are truncated into something indecipherable when I export to a new table.</SPAN><BR /><BR /><SPAN>Since I cannot add fields to a joined table, my idea of creating new fields with the names I want after each join does not work.&nbsp; Any idea how I can do this join and retain meaningful field names?</SPAN></BODY></HTML> Mon, 07 Apr 2014 18:54:20 GMT https://community.esri.com/t5/python-questions/manipulating-field-names-on-join/m-p/57157#M4529 JamesHook 2014-04-07T18:54:20Z