Automatically add and remove entities and relationships based on source table

[PJCapio]

Good day,

Is there a way for ArcGIS Knowledge to automatically detect changes (such as addition and removal of entities) from a source table and then implement it into the investigation? So far, what we are only able to do is to use Load Table after adding entries to the source table to add entities and relationships to the investigation. However, we also found that removing entries from the source table and using Load Table does not produce the same effect, such that the removed entries in the source table should also be removed from the investigation. As for the source format, we have tried using a local excel file and an enterprise geodatabase feature class as source tables. 

We're really interested if there is a more streamlined workflow for adding and removing data in the investigation. Thank you in advance!

[MeganBanaski1 · Accepted solution]

Hello! First of all, thank you for this question and feedback!

Currently there is no direct connection to the source table to have this streamlined workflow of keeping the source table and knowledge graph in sync. Load table will always only add new data from the input table, if other data needs to be deleted you can do so in the investigation, link chart or map using the available editing tools. 

[PJCapio]

Hi Megan,

Thank you very much for the response!

[xingchenc]

It would be a huge plus if we can delete entities and relationships in bulk, whether using the Cypher query or the load table tool.