How to Merge All Tables into One Table in a Filegeodatabase

JohnPapageorgiou — Fri, 17 Feb 2017 22:08:42 GMT

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-script

Thanks in advance,

John

Re: How to Merge All Tables into One Table in a Filegeodatabase

JohnPapageorgiou — Fri, 17 Feb 2017 23:05:27 GMT

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

topic Re: How to Merge All Tables into One Table in a Filegeodatabase in Python Questions

How to Merge All Tables into One Table in a Filegeodatabase

Re: How to Merge All Tables into One Table in a Filegeodatabase