Unable to link a node with itself using Neo4j

user_13366713 0
Viewed 51

How can I create a relationship from a node to itself? I have one node (p:person) and my csv has 2 columns: name and vice. Each row in my csv represents a person who a ceo and their vp at the time. Now sometimes vp were ceo so I want to show that relationship. Here is what I was trying but no luck. If I do not include the WITH I receive error saying I need it but when I add the * or a property, it says it cannot find row. I'm stuck

:auto USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM 'file:///ceo_vp.csv' AS row 

CREATE (p:person {name:coalesce(row.name,'UNK')})
MATCH (p:person {name:row.vice })
WITH * 

CREATE (p)-[:was_vp_for]->(p)
graph-databases neo4j
1 Answers

There is typo on the variable p; You must assign a different variable name for vp. Here is the script;

LOAD CSV WITH HEADERS FROM 'file:///ceo_vp.csv' AS row 

MERGE (ceo:person  {name:coalesce(row.name,'UNK')})
MERGE (vice:person {name:row.vice })
CREATE (vice)-[:was_vp_for]->(ceo)

Notice that I used merge because as you said, a vp can be a former ceo (and vice versa) so merge is better than create. Merge will ignore the person if it already exists.

user_73718930
Related