haydlew

merge_management table limits?

Discussion created by haydlew on Sep 22, 2011
Latest reply on Sep 22, 2011 by haydlew
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?

Outcomes