How to Merge All Tables into One Table in a Filegeodatabase

981
1
02-17-2017 02:08 PM
JohnPapageorgiou
New Contributor III

Hi,

I have written a script that buffers a point and then that buffer performs select by location on 80 feature classes/shapefiles.  If there are any hits, they are output as file geodatabase tables(in one file geodatabase) and .xls files(in one folder).  I would like to add the functionality of merging all the output tables in the gdb into one table.  I'm facing several challenges. One is with my workspace, in order to output both gdb tables and xls files I've set it to be the project folder that contains both the file geodatabase and the folder to contain the spreadsheets.  Eventually I would like to phase out the output of all the spreadsheets and just output one spreadsheet, the merged file geodatabase table.  I've read through several threads and tinkered with what I have to no avail, any help is appreciated.  Let me know if there is any other information you'd like me to provide.

The pertinent links are below:

https://community.esri.com/thread/34910
https://community.esri.com/thread/53508
http://gis.stackexchange.com/questions/101919/merge-from-arcpy-listtables-producing-duplicate-rows
http://gis.stackexchange.com/questions/93346/can-arcpy-env-workspace-be-set-multiple-times-in-same-s...

Thanks in advance,

John

Tags (1)
0 Kudos
1 Reply
JohnPapageorgiou
New Contributor III

The issue of merging all the tables in the file geodatabase is solved!  I redirected my workspace to the file geodatabase that has all the output tables.  Modifying my workspace to point to a folder to export an .xls file is still proving a challenge.

thanks,

John

0 Kudos