nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

merge multiple tables with Merge_management?

leewalston

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.

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

RDHarles

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?

MatthiasAbele

Hallo,

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

Yours

Matthias

RDHarles

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/

MatthiasAbele

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

RDHarles

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

MatthiasAbele

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). 
>>>

RDHarles

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?

MatthiasAbele

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

tables_to_be_merged.zip

RDHarles

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)?

MatthiasAbele

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

Matthias

leewalston

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.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.