merge_management table limits?

393
1
09-22-2011 06:44 PM
HaydenLewis
New Contributor II
I have an issue with merge_management. I have a script that loops through all tables in a geodatabase and uses them in merge management.

[HTML]import arcpy, string, os, sys
from arcpy import env
env.workspace = "F:\\TEMP\\VLUIS2009.gdb\\"
ftstring= ""
outputfc="F:\\TEMP\\zonalstatsV2all.dbf"
rtyu= '"'
arcpy.env.overwriteOutput = True
tableList = arcpy.ListTables()
for table in tableList:
    ftstring=ftstring+'"'"F:\\TEMP\\VLUIS2009.gdb\\"+str(table)+'"'","
abcd = "["+ftstring+"]"
arcpy.Merge_management(abcd,outputfc)[/HTML]

Problem is that only half of the tables get merged and it completes successfully without error. From the source tables there are 2.7million rows, but only 1 million of them come across in the merged table. Is there a limit to the number of tables in a merge request?
Tags (2)
0 Kudos
1 Reply
HaydenLewis
New Contributor II
Figured out exporting to dbf file apposed to a feature table was the problem. Now all rows are in merged table!
0 Kudos