Guest User

Untitled

a guest
Dec 4th, 2017
363
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. id;title;startdate;enddate;budget;description;department;supervisor;supervisor_email;member;member_email;tags
  2. 49206;Some title;29.09.2015;27.04.2016;4 billion;Something about the title;ABC;Person1;person1@aol.com;Person2, Person3;person2@aol.com, person3@aol.com;Some tags
  3.  
  4. LOAD CSV WITH HEADERS FROM 'file:///..../Project.csv' AS row FIELDTERMINATOR ';'
  5. MERGE (pr:Project {projectID: row.id, title: row.title, startdate: row.startdate, enddate: row.enddate, budget: row.budget})
  6. FOREACH (n IN row.member_email |
  7. WITH SPLIT(row.member_email, ", ") AS memberEmails
  8. MERGE (p:Person {email: memberEmails})
  9. MERGE (p)-[:IS_MEMBER]->(pr)
  10. )
Add Comment
Please, Sign In to add comment