Load relationships between entities of the same type

AnnyHuang

I am using the Load Table option to create my knowledge graph, had no problem until importing a table that contains relationships between the same entities.

E.g. Stakeholder 1 is related to Stakeholder 2. Both are the same Entity Type 'Person'.

My table looks like:

Stakeholder_ID, RelatedTo_ID, Relationship_Title

1, 10, Manager

Screenshots of what I attempted in Load Table:

 

 

I checked 'Merge' because I already have stakeholders loaded. What ended up after running the load table action is that many Stakeholder entities were created with null Stakeholder_ID, and some relationships have null as the origin or destination.

 

KeiranBray

Hey @AnnyHuang might need to check the properties for the entities and what they're merging on. when you're loading two different fields of data into the one entity type (stakeholder), you want to make sure that the property that is getting used to merge is named the same across the entities.

An example with screenshots below I have a column with employee name and another column with manager name (in your case this would be the stakeholder_id and related_to_ID both going into a employee entity. I'm making sure that they're merging on the same property field, this should then remove the circular relationships or duplicates, if there are fields cells that are empty in your data, leave them empty as it might pick up characters:

Entities

Relationships:

Properties employee name:

Properties for Manager_name:

Example output:

Starting table (subbing out names for IDs):

 

Let me know how it goes, happy to take a look at an example table you might have.

Cheers

Keiran