Create relation type between nodes based on the csv

[vence_andersen1 (Graham Fernando)]

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]

Check this link to create dynamic relationship:

How to create dynamic relations from csv with 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…