How to avoid duplicate and to create relationship dynamically in neo4j with csv data

[Ganesh Babu]

Hi All,

 

I am trying to build graph with the following csv data using cypher query,

 

Name,Team

ganesh,misra

jayakumar,misra

misra,vinoth

vinoth,ganesh

chinmaya,mano

mano,darga

 

Below is the cypher query I tried,

 

LOAD CSV WITH HEADERS FROM "file:///dummy.csv" AS csvLine

MERGE (team:Team {Team: csvLine.Team})

CREATE (name:Name {Name: csvLine.Name})

CREATE (name)-[:WORKING_WITH]->(team)

Below is the response that I got in neo4j browser,

I want to remove the duplicate name in the graph and to create relationship dynamically and it should be connected with each other based on the data. Below is the expected graph I am looking for it. How to achieve this using cypher query?

Please let me know your thoughts and please correct me if I am doing anything wrong in the cypher query.

Thanks,
Ganeshbabu R

[Russ Burkert]

Ganesh

Just change the Create to Merge and I think you will get the results you need

--
You received this message because you are subscribed to the Google Groups "Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Michael Hunger]

I think there is some confusion in your data, it's not really Person and team but person works with person.

LOAD CSV WITH HEADERS FROM "file:///dummy.csv"

 AS csvLine

MERGE (p1:Person {name: csvLine.Team}) 

MERGE (p2:Person {name: csvLine.Name}) 

MERGE (name)-[:WORKING_WITH]-(team)

To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google Groups "Neo4j" group.

To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscribe@googlegroups.com.

[Kamal Murthy]

The last MERGE statement should be like this:

MERGE (p1:Person {name: csvLine.Team}) 

MERGE (p2:Person {name: csvLine.Name}) 

MERGE (p2)-[:WORKING_WITH]-(p1)

-Kamal

[Ganesh Babu]

I tried with your suggestions and it worked as expected.

Thanks for your response.

- Ganesh