Select to view content in your preferred language

Automatically appending a new feature from one table to another table

68
2
yesterday
Labels (1)
RudyJamet
Emerging Contributor

I have 2 similar but unrelated feature layers, one is the original and the other a "clone" with all the same records but with a different default sorting.

How can I set up a way to append new records from the original table layer to the clone layer table automatically? Is it through Relationship Class? Do I need a Python/Arcade expression?

Thanks for your input.

 

0 Kudos
2 Replies
RyanUthoff
MVP Regular Contributor

The answer might depend on your DBMS. What type of database is your data in? An enterprise geodatabase, file geodatabase, etc.?

If it is an enterprise geodatabase, I believe you can setup a trigger in the DB that triggers when a new record is inserted into the table that will write that record to the other table. 

Unfortunately, I don't think automatically copying records from one table to another upon insert of a new record is something that is possible in a file geodatabase, but someone might be able to correct me if I'm wrong. My best advice for that scenario would be to create a model or script that periodically syncs the original table with the cloned table.

On a side note, I don't know what your use case is for creating the "cloned" table, but if it's just for the purpose of sorting, you can just create a "copy" of the layer in the table of contents in ArcGIS Pro and change the sorting that way. That way you have two different layers in the map with different sorting, but they are both using the same source table so you don't have to deal with two different copies of the same table. Meaning that any updates you make in that table will be reflected in all copies you made in the table of contents.

RudyJamet
Emerging Contributor

My data are stored in a file geodatabase, so I think I will try your suggestion about creating a model that would periodically syncs new data from one table into the other.

Thank you for your help Ryan, and happy new year!