topic Re: Automatically add and remove entities and relationships based on source table in ArcGIS Knowledge Questions

Automatically add and remove entities and relationships based on source table

PJCapio — Fri, 09 Sep 2022 07:32:37 GMT

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!

Re: Automatically add and remove entities and relationships based on source table

MeganBanaski1 — Fri, 09 Sep 2022 12:29:10 GMT

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.

Re: Automatically add and remove entities and relationships based on source table

PJCapio — Mon, 12 Sep 2022 03:38:13 GMT

Hi Megan,

Thank you very much for the response!

Re: Automatically add and remove entities and relationships based on source table

xingchenc — Fri, 30 Sep 2022 05:41:35 GMT

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.