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.

  • February 7, 2022
  • 2 replies
  • 6 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??

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

    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    2 replies

    hkingsbury
    Celebrity
    Forum|alt.badge.img+63
    • hkingsburyCelebrity
    • Celebrity
    • 1625 replies
    • 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

    E
    • evandenheuvel
    • Author
    • 1 reply
    • 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

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

    You're awesome! :)

    Community Stats

    32,070
    Posts
    121,771
    Replies
    39,694
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    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.