I have a shapefile that I want to programatically join with 12 other tables, retaining exactly 2 fields from each of the join tables.
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.
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. Any idea how I can do this join and retain meaningful field names?
