Hi all, I have a csv file containing: "FromNode","RelationType","ToNode" "Cybersecurity knowledge","CONNECTED","Vulnerabilities" "Cybersecurity knowledge","RELATED","Mitigations" Trying to load from csv I used this (wrong) statement: LOAD CSV WITH HEADERS FROM "file:///relations.csv" AS row MA…

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 comment was with regards to the requirement that a Cypher statement (unless consisting only of a single CALL) must end with either a RETURN or a writing clause (MERGE, CREATE, SET, REMOVE, DELETE). Basically, you cannot end your statement on a CALL, that won't compile. If you don't need to retu…

I am trying to do the same, but along with creating the nodes as well. I tried this: LOAD CSV WITH HEADERS FROM "file:///COVID_Edges.csv" AS row MERGE (src:Character {name: row.Source}) MERGE (tgt:Character {name: row.Target}) CALL apoc.create.relationship(src, row.Relation,{}, tgt) YIELD rel REMO…

Use WITH src, tgt before the CALL statement

How to create dynamic relations from csv with apoc?

Neo4j Graph Platform Procedures & APOC

MirtoBusico (Mirto Busico) December 28, 2018, 7:04pm 3

Thanks a lot: it worked.

Please, can you explain

If you need the equivalent of a no-op then you can remove a non-existent property from a node or relationship

I don't understand when and how

REMOVE rel.noOp

works

How to add entities and relations with in CSV

Topic		Replies	Views
How to create dynamic relations from csv with apoc? Neo4j Graph Platform migrated	1	143	August 25, 2022
Create relation type between nodes based on the csv Cypher	1	538	September 3, 2021
How to add entities and relations with in CSV Cypher cypher , operations , import , knowledge-base	8	565	June 4, 2021
How to reference the relationship variable when loading from csv? Neo4j Graph Platform	6	1011	November 9, 2020
Possible to create nodes and relationships between them at once when loading from CSV? Neo4j Graph Platform	4	485	September 9, 2021

Take the Course Then Join The Aura Agent Hackathon

How to create dynamic relations from csv with apoc?

Related topics

Take the Course Then Join
The Aura Agent Hackathon