Create relation type between nodes based on the csv

[vence_andersen1]

So I have 2 CSV file, 1 has details about all the nodes like their names and properties and the other CSV has the type of relation between 2 nodes, there are multiple types of relation between nodes. Eg: A (node) - Parent(relation type) - B(node), A(node) - child(relation type) - C(node), D(node) - sibling(relation type) - D(node).

I have also attached a pic, they are the id's representing a node, left is node 1, right is 2nd node, middle is the type of relation.

Can I use this table to define the relation between nodes, i referred Create relationship from CSV on existing nodes to create relation between nodes, but all the realtion types are of same name.

[ameyasoft · Accepted solution]

Check this link to create dynamic relationship:

How to create dynamic relations from csv with apoc? Procedures & APOC

Unless the CALL is the only thing in the query, you need to explicitly YIELD variables from the call (using call apoc.help('create.rel') shows us this procedure yields arel` variable), and as in the message you can't end the query with a CALL, it needs to be a writing clause or a return. If you need the equivalent of a no-op then you can remove a non-existent property from a node or relationship: LOAD CSV WITH HEADERS FROM "file:///relations.csv" AS row MATCH (f:Node), (s:Node) WHERE f.Name = r…