create dynamic relationships between nodes in neo4j from csv file

Question

Hi Have a CSV file and I want to create nodes and relationships simultaneously
Im using below query to create nodes

using PERIODIC COMMIT 1000
load csv from "file:///home/gaurav/sharing/dataframe6.txt" as line fieldterminator" "
 MERGE (A :concept{name:line[0]})
 WITH line, A
 MERGE (B :concept{name:line[1]})
 WITH line, A, B
 create (A)-[:line[3]]->(B);  // This is trouble part

but when I try to create relationship between imported nodes then I get error

Invalid input '[': expected an identifier character, whitespace, '|', a length specification, a property map or ']' (line 7, column 18 (offset: 218))
"create (A)-[:line[3]]->(B);"

Dave Bennett Dave Bennett · Accepted Answer · 2017-05-25T16:37:08

If you truly want to create relationship in a dynamic fashion you need to use an APOC procedure, specifically apoc.create.relationship.

using PERIODIC COMMIT 1000
load csv from "file:///home/gaurav/sharing/dataframe6.txt" as line fieldterminator" "
MERGE (A :concept{name:line[0]})
WITH line, A
MERGE (B :concept{name:line[1]})
WITH line, A, B
CALL apoc.create.relationship(A, line[3], {}, B) YIELD rel
RETURN A,B,rel

create dynamic relationships between nodes in neo4j from csv file

2 Answers