Select to view content in your preferred language

Updating feature class from view on daily using python

1819
10
Jump to solution
10-14-2024 08:04 AM
Labels (2)
vijaybadugu
Frequent Contributor

We have created a view to get the data from multiple tables. I tried publishing same view with sync enabled feature service, However, it did not work due to limitation on view. So, I created same feature class with same fields, published with sync (archiving) enabled. I need to update this feature class on daily basis to see the latest data in field maps. 

I have already python script (job) to update this feature class on daily. which deletes entire data from the feature class and copies from view. 

Is there a way to do this process ESRI best practices?

0 Kudos
10 Replies
RobertKrisher
Esri Regular Contributor

The tool updated the rows it found matches for, then inserted the rows it couldn't find matches for. Doing both an insert and an update is what the append tool does when you select the Matching fields options. This is why this is often referred to as doing an "Upsert" because the tool will first "Update" rows it matches, then "Insert" the rows it doesn't.

0 Kudos