I would like to replace existing feature class data with new shapefile data. I receive periodic data updates in shapefile format that I would like to apply to existing feature classes. IE existing feature class has 20 k rows of data, new file is updated with 2000 new rows of data, so 22k rows in the new shapefile.
I thought truncate (then load) would work, but getting an error. Is there a more straight forward method I'm missing?
Any advice greatly appreciated ,....Thanks!!
using ArcGIS 10.4.1
Solved! Go to Solution.
Thanks, I always receive a complete new file (rather than just the new records). So there's some edits, and new records.
So I prefer to just replace the records all together. I just tried "delete rows (data management)" , then loaded the new data. Worked fine, but is that a reliable efficient solution? For the number of files I have to update, its not a big deal........
worked great, thank you. Must beware of lack of warnings though, as I inadvertently overwrote a line file with a point file, different table structure.
Handy for me though, thanks again!
While jayanta.poddar has answered your question I'll add a little tidbit as well: I overwrite existing feature classes all the time, using the delete features tool, followed by the append tool in a model. By doing so, I maintain the original schema of my target feature class, empty it out and replace it completely. Using the append tool in a model is great in it allows you to set up mapping fields from the source data to the target data once and only once.