Is this the expected behavior of the Make Table Query or perhaps I am misusing this tool, and should stay with sde command line, which takes a few seconds to process this much data. This is how output csv table looks in Excel:Īs one can see table is not sorted - minor issue. The process ran for 23 hours before I killed it because it sucked up about 23 GBs of memory in my Local Setting Temp directory.

Deselect all fields and the resulting table will not have duplicates in the fields. Rows = arcpy.da.TableToNumPyArray(letter,sourceList)ĭf = pd.om_dict(joined,orient='index')ĭf.to_csv ('C:/scratch/bca.csv', header=True) The Make Query Table tool creates duplicate fields in the output table when all fields from all tables are included. To test it I created 3 identical tables named 'A','B','C':Īrcpy.AddMessage('Joining %s to %s' %(letter,first))Ī(first,'fromn', letter, 'fromn')Īs one can see you don't have to bother with field naming, ArcGIS handles duplicate names nicely.Īs alternative you might use dictionary: import arcpy

Esri make query table tool 10.5