Hi, I new using Neo4j so I began with a very basic example.I have a table
with this info:
Bill_To_Adress_provided Arriving_Airport Departing_Airport
Address 1234 COR BUE
⁞ ⁞ ⁞
So I did a graph with 3 nodes: Adress, Arrive, Depart and the relationship
between them. This is the query:
CREATE CONSTRAINT ON (a:Address) ASSERT a.id IS UNIQUE;
CREATE CONSTRAINT ON (b:Arrive) ASSERT b.id IS UNIQUE;
CREATE CONSTRAINT ON (c:Depart) ASSERT c.id IS UNIQUE;
USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM
"file:f:/address/to/the/table.csv" as transactions
FIELDTERMINATOR ';'
MERGE (address:Address {id: transactions.Bill_To_Adress_provided})
MERGE (arrive:Arrive {id: transactions.Arriving_Airport})
MERGE (depart:Depart {id: transactions.Departing_Airport})
CREATE (address)-[r:FROM]->(arrive)
CREATE (depart)-[s:TO]->(address)
;
<https://lh3.googleusercontent.com/-hpwppzHCcPQ/V3_MM0tGM_I/AAAAAAAAAE8/bmY2MoAithkSNuawCQ7FFRCanwHzEUD8gCLcB/s1600/traffic.jpg>
But now I want to merge Arriving_Airport with Departing_Airport in a node
call Airport. How can I do that?.
Regards,
--
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
