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; } } }

Iterate tables through Python

MeredithGreen

I have a script listed below:

tables = arcpy.ListTables("res*")

for table in tables:

res_500yrsumm = os.path.join(output_workspace, str("res_500yrsumm"))

res_summ = os.path.join(output_workspace, str("res_summ"))

arcpy.CopyRows_management(res_500yrsumm, res_summ)

arcpy.DeleteRows_management(res_summ)

arcpy.Append_management(table, res_summ, "NO_TEST", "", "")

There are seven tables it is suppose to iterate through and append to res_summ but for some reason it only does one table and stops. I appended all of the tables separately in ArcMap using the append tool to make sure there were no issues with fields matching and it worked fine. Is there an error in my script I'm not seeing? Any help would be greatly appreciated.

Encuentra más publicaciones etiquetadas con

Accepted answers

SepheFox

Hi Meredith, It looks like you are creating your res_summ table anew for each iteration, overwriting the previous one each time. Try taking the copy/delete rows outside of the loop.

All comments

MeredithGreen

Using the suggestions I adjusted the scrip to look like this:

res_500yrsumm = os.path.join(output_workspace, str("res_500yrsumm"))

summ_res = os.path.join(output_workspace, str("summ_res"))

arcpy.CopyRows_management(res_500yrsumm, summ_res)

arcpy.DeleteRows_management(summ_res)

tables = arcpy.ListTables("res*")

for table in tables:

arcpy.Append_management(table, summ_res, "NO_TEST", "", "")

And everything is doing what it is suppose to be doing. Thanks for the tips!

DarrenWiens2

Since you've already made a list of tables (the input tables argument for Append can be a list), you can use that in Append. No loop required.

tables = arcpy.ListTables("res*")
res_summ = os.path.join(output_workspace, str("res_summ"))
arcpy.Append_management(tables, res_summ, "NO_TEST", "", "")

SepheFox

Hi Meredith, It looks like you are creating your res_summ table anew for each iteration, overwriting the previous one each time. Try taking the copy/delete rows outside of the loop.

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