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.

Finde mehr Beiträge mit dem Tag

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.

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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