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

Batch Processing in Model Builder - Delete rows then Append

SanhitaChatterjee1

I am trying to delete rows from multiple feature classes with prefix TCEMaster_* (such as TCEMaster_Centerline, TCEMaster_Fence etc.) in TCEMaster.SDE ----then append the feature classes with data from another sde. Names of the feature classes in Input dataset is without the prefix (such as Centerline, Fence etc.).

My ultimate goal is to run a script/batch file routinely.

Should I use modelbuilder with Iterator and then export to python or a script in python. I am not much of an expert in python. See attached what I got started in modelbuilder. I have also attached a screenshot of the databases exported to FGDB for testing purposes. Target dataset is TCEMaster in test_TCE.gdb and input dataset is R0007199 in test.gdb.

Any help will be highly appreciated.

ModelBuilder.JPG

Databases Screenshot.JPG

Find more posts tagged with

Accepted answers

All comments

Are those TCE feature classes versioned? If not, using truncate is faster than delete rows.

Also, if you want to run this as a scheduled job, you'll need to use Python.

# Process: Append

for fc in Inputdataset:

arcpy.Append_management(fc, fcs, "TEST", "", "")

Instead of for fc in Inputdataset:

for fc in arcpy.ListFeatureClasses('*','All',Inputdataset):

SanhitaChatterjee1

Specific feature dataset "TCEMaster" and all FCs in this feature dataset

Do you want to process all feature classes in a file geodatabase?

Or are you trying to process all feature classes in a specific feature dataset in a file geodatabase?

SanhitaChatterjee1

Can you please tell me what parameter is missing here in the python iterator?

Input dataset is Temp_test.gdb\\R0007199

Target dataset is test_TCE.gdb\TCEMaster

Target dataset has a wildcard TCEMaster_*

Both datasets have same schema- only difference is the wildcard in target dataset.

# Import arcpy module

import arcpy

arcpy.env.workspace = "C:\Users\sc\Desktop\test\test_TCE.gdb\TCEMaster"

fcs = arcpy.ListFeatureClasses("TCEMaster_*")

Inputdataset = "C:\\Users\\sc\\Desktop\\test\\Temp_test.gdb\\R0007199"

Targetdataset = "C:\Users\sc\Desktop\test\test_TCE.gdb\TCEMaster"

# Process: Append

for fc in Inputdataset:

arcpy.Append_management(fc, fcs, "TEST", "", "")

Start with model builder for 1 feature class and then export out to python. Python has some great tools for iterating.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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