cancel
Showing results forΒ 
Search instead forΒ 
Did you mean:Β 

Head's Up! Site maintenance this Wednesday, February 1. Disruptions expected as we migrate the forums.

Load data from CSV and connect nodes to a single parent node

Hi, I'm new to Cypher and I'd like to create a couple hundred new nodes from a CSV file and branch these off from a single parent node. What Cypher statement can I use to create the single parent node and then upload and link the CSV data? I'm thinking something like this: LOAD CSV FROM 'https://data.neo4j.com/bands/artists.csv' AS line CREATE (n:Artists)-[:ARTIST]->(:Artist {name: line[1], year: toInteger(line[2])})

Am not sure how to create the single parent node and relationships which the CSV data will create?

1 REPLY 1

glilienfield
Ninja
Ninja

You could create the node before the import and β€˜match’ to retrieve it in the query, or β€˜merge’ it in the query to β€˜create’ it if it doesn’t exist and match it to retrieve it

Try the following, assuming it was already created and has β€˜id’ property of 100.  Substitute any predicate that works. 

 

Match (n:Artist{id:100})

with n

LOAD CSVFROM 'https://data.neo4j.com/bands/artists.csv'AS line

merge (n)-[:ARTIST]->(:Artist{name: line[1], year: toInteger(line[2])}