Solved

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

  • 7 February 2022
  • 2 replies
  • 0 views
E

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??

icon

Best answer by hkingsbury 7 February 2022, 19:59

View original

2 replies

hkingsbury
Rank
Userlevel 5
Badge +29

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

Check out the Abley FME Firesides on Youtube: https://www.youtube.com/@ableyltd
E

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! :)

Reply


Community Stats

28,692
Posts
109,432
Replies
36,542
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.