Skip to main content
Solved

We are trying to replace a subset of GIS data based upon a criteria (county) with data from another table.


We can't seem to get it to work using any of the available transformers, nor any of the help we've searched for online. We just end up with either the data in the output table staying the same, or an error in the transformation. We are using a standard file GDB in ArcMap with a FC containing about 10 million records, and we want to replace about 200,000 of those records with updated info that is located in another FC in the GDB (based on a common field (county)).

 

Is there a way to do this??

Best answer by hkingsbury

Your order of operations will be

  1. Delete old data
  2. Read in new data
  3. Insert new data

This will make use of feature readers and feature writers

image

View original
Did this help you find an answer to your question?

2 replies

hkingsbury
Celebrity
Forum|alt.badge.img+55
  • Celebrity
  • Best Answer
  • February 7, 2022

Your order of operations will be

  1. Delete old data
  2. Read in new data
  3. Insert new data

This will make use of feature readers and feature writers

image


hkingsbury wrote:

Your order of operations will be

  1. Delete old data
  2. Read in new data
  3. Insert new data

This will make use of feature readers and feature writers

image

Thank you so much! this makes total sense, and isn't something we thought to try!

You're awesome! :)


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings