topic Re: merge multiple tables with Merge_management? in Python Questions

merge multiple tables with Merge_management?

leewalston — Tue, 23 Aug 2011 18:58:22 GMT

Hello,

Can anyone tell me how to merge multiple dbf tables from the same folder into one large dbf table? Let's say I have 5 dbf tables with identical schema in the following folder: "C:\\Data\\Tables". I've tried listing the tables and using that object as the input, but to no avail. I haven't found much help on other forums as well...

This sounds so simple, but for some reason I can't figure it out:

gp.workspace = "C:\\Data\\Tables"
tablelist = gp.ListTables("*")
gp.Merge_management(tablelist, "C:\\Data\\Tables\\merged.dbf")

Thanks for any input.

Re: merge multiple tables with Merge_management?

RDHarles — Sat, 11 Dec 2021 12:36:43 GMT

You can do it in Arc10:

import arcpy, os
arcpy.env.workspace = "c:/junk"
tableList = arcpy.ListTables()
arcpy.Merge_management(tableList, "easy.dbf")

In 9.x, it's much more involved.

What version of Arc are you using?

Re: merge multiple tables with Merge_management?

MatthiasAbele — Wed, 24 Aug 2011 13:06:35 GMT

Hallo,

that is a nice code snippet...I am new to python; how can I make a skript from this?

Yours

Matthias

Re: merge multiple tables with Merge_management?

RDHarles — Wed, 24 Aug 2011 13:55:58 GMT

Hallo,

that is a nice code snippet...I am new to python; how can I make a skript from this?

Yours

Matthias

The piece of code above will run as it is. You just need to copy it and save it as a file (e.g. script.py).
There are many ways/places to run python scripts.
Here's a link that describes one way to do it:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/A_quick_tour_of_creating_script_tools/001500000006000000/

Re: merge multiple tables with Merge_management?

MatthiasAbele — Sat, 11 Dec 2021 12:36:46 GMT

Thank you, I will read through this...I tried your script with norma (yellow) tables...it was working very nicely; but with dbf tables...it is not working for me.

Here is the message:

>>> import arcpy, os
... arcpy.env.workspace = "C:\Users\admin\Desktop"
... tableList = arcpy.ListTables()
... arcpy.Merge_management(tableList, "easy.shp")
... 
Runtime error <class 'arcgisscripting.ExecuteError'>: Failed to execute. Parameters are not valid. ERROR 000732: Input Datasets: Dataset fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg0p0avk0p2_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg0p2avk0p4_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg0p4avk0p6_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg0p6avk0p8_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg0p8avk1p0_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg1p0avk1p2_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg1p2avk1p4_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg1p4avk1p6_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg1p6avk9p0_final.dbf does not exist or is not supported Failed to execute (Merge). 
>>>

What could be the reason?

Thanx,

Matthias

Re: merge multiple tables with Merge_management?

RDHarles — Sat, 11 Dec 2021 12:36:49 GMT

Thank you, I will read through this...I tried your script with norma (yellow) tables...it was working very nicely; but with dbf tables...it is not working for me.

Here is the message:

>>> import arcpy, os
... arcpy.env.workspace = "C:\Users\admin\Desktop"
... tableList = arcpy.ListTables()
... arcpy.Merge_management(tableList, "easy.dbf")
... 
Runtime error <class 'arcgisscripting.ExecuteError'>: Failed to execute. Parameters are not valid. ERROR 000732: Input Datasets: Dataset fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg0p0avk0p2_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg0p2avk0p4_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg0p4avk0p6_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg0p6avk0p8_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg0p8avk1p0_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg1p0avk1p2_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg1p2avk1p4_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg1p4avk1p6_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg1p6avk9p0_final.dbf does not exist or is not supported Failed to execute (Merge). 
>>>

What could be the reason?

Thanx,

Matthias

At first glance, you have your slashes wrong in the workspace path, try this:
"C:/Users/admin/Desktop"

Also, the output file should either be have a .dbf extension on it (my mistake) or should point to a file geodatabase like this:
test.gdb/table

Re: merge multiple tables with Merge_management?

MatthiasAbele — Sat, 11 Dec 2021 12:36:51 GMT

Thanx, but I still get an error:

>>> import arcpy, os
... arcpy.env.workspace = "C:/Users/admin/Desktop"
... tableList = arcpy.ListTables()
... arcpy.Merge_management(tableList, "easy.dbf")
... 
Runtime error <class 'arcgisscripting.ExecuteError'>: Failed to execute. Parameters are not valid. ERROR 000732: Input Datasets: Dataset fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg0p0avk0p2_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg0p2avk0p4_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg0p4avk0p6_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg0p6avk0p8_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg0p8avk1p0_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg1p0avk1p2_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg1p2avk1p4_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg1p4avk1p6_final.dbf;fglr_o_fr_500m_C280_RNW_u_v_vBETRAG_neu_flussschlauch_vg1p6avk9p0_final.dbf does not exist or is not supported Failed to execute (Merge). 
>>>

Re: merge multiple tables with Merge_management?

RDHarles — Wed, 24 Aug 2011 14:48:31 GMT

Thanx, but I still get an error:

Not sure why it won't work for you??? I ran it from 2 different environments and it worked fine.
From where are you running this script?

Re: merge multiple tables with Merge_management?

MatthiasAbele — Thu, 25 Aug 2011 06:11:23 GMT

Hallo,

I ran it serveral times...with .info-tables it is working perfectely. But with info-tables, the file name length seems to be limited. Therefor I will have to work with .dbf-tables.
With dbf-tables I always get error messages, independently of the file name length:

Runtime error <class 'arcgisscripting.ExecuteError'>: Failed to execute. Parameters are not valid. ERROR 000732: Input Datasets: Dataset fglr78.dbf;fglrjk.dbf does not exist or is not supported Failed to execute (Merge).

Attached are 3 out of many dbfs I would like to merge. Perhaps you can try it.

Yours,

Matthias

Re: merge multiple tables with Merge_management?

RDHarles — Sat, 11 Dec 2021 12:36:54 GMT

I just ran this script:

import arcpy, os
arcpy.env.workspace = "c:/junk/dbf/mergeEasy"
tableList = arcpy.ListTables()
arcpy.Merge_management(tableList, "easy.dbf")

...on the data you posted and it worked fine for me.
Not sure what your doing differently on your end?

Also, what do you mean by the difference between .info-tables & info-tables? (.dbf vs. file geodatabase)?

Re: merge multiple tables with Merge_management?

MatthiasAbele — Thu, 25 Aug 2011 12:14:14 GMT

No idea...now it is working, but thanx!

Matthias

Re: merge multiple tables with Merge_management?

leewalston — Sat, 11 Dec 2021 12:36:57 GMT

You can do it in Arc10:
import arcpy, os
arcpy.env.workspace = "c:/junk"
tableList = arcpy.ListTables()
arcpy.Merge_management(tableList, "easy.dbf")
In 9.x, it's much more involved.

What version of Arc are you using?

Thanks! The code you provided worked. I swear that at one time I tried that very same piece of code and I got an error. Sometimes you just need to step away for a while or get a fresh pair of eyes on it. Thanks again. ..... oh, and I'm using 10.0.