Hi, I have three arrays of objects as shown below: const org = [ { id: "orgId1", name: "first organization" }, { id: "orgId2", name: "second organization" } ] const location = [ { id: "loc1", name: "Texas" }, { id: "loc2", name: "New York"…

This should work, note that there is only one UNWIND for index (variable i) and the with between the 2 merges, to "activate" the merging mechanism through the variable o : UNWIND range(0, size($orgs) - 1) as i with i MERGE (o:Organization { id: $orgs[i].id })-[r:LOCATED_AT]->(l:Location {id: $locs[…

CURRENT SUBMISSIONS ✦ @mabu.mateApple HealthGraph Agent✦ @venkatasaiprasadpDepGraph Agent✦ @dhiraj.patraRegulatoryRisk GraphAgent✦ @shantanunitw01CineGraph AI✦ @jevlachovKorca Triage Agent✦ @deanfouldsJapan Seismic Risk Intelligence Graph✦ @jonas.koennerConspiracyGraph Agent✦ @mahanteshimathFinSight✦ @prashant7090Detect Cyber Attack✦ @ochiengokumu482VAT-TaxGraph AI✦ @shrikantbhadaneAura-Health-Bot✦ @violet.ols.devRecallScope Agent✦ @tarunnarang1992ReviewGraph AI✦ @epiphanyanEarnings Call Graph Analyst✦ @wanga.15065M-Pesa (Kenya) Insight Agent✦ @kumar20051020shivamVibeGraph AI✦ @jakub.kierznowskiiiDrugPath✦ @vinod.nageshwarGeospatial Supply Chain Agent✦ @winleexzCPF Customer Agent✦ @hellopriyanshu4FraudGraph Sentinel✦ @ayushdeosinghHostLens AI✦ @joslatMarketMind✦ @priyagijain IPL Cricket Intelligence Agent ✦ @Rodrigo-Tenorio Chess Analytics Assistant ✦ Submit your Aura Agent Project to appear here

Neo4j Online Community

Adding relationships between an array of array of objects

Neo4j Graph Platform Cypher

risingodegua (Risingodegua) September 14, 2021, 2:33pm 3

giuseppe_villan:

UNWIND range(0, size($orgs) - 1) as i
with i
MERGE (o:Organization { id: $orgs[i].id })-[r:LOCATED_AT]->(l:Location {id: $locs[i].id}) 
with o, i
MERGE (o)-[r2:CONTACT_AT]->(l2:Contact {id: $contacts[i].id})

Worked perfectly. Thanks

Topic		Replies	Views
Iterating through an array of ids to create relationships between them Cypher cypher	6	4279	July 22, 2023
Multiple relationships with one query, loop-function?!? Newbie Questions relationship	10	1766	February 20, 2021
How do I create a cypher query to retrieve nested array in JSON data file? Cypher	10	497	October 31, 2021
Struggling to Draw Relationship from index i of List1 to index i of List2 Cypher cypher , javascript , js-driver	4	636	May 17, 2020
Merge of Relationships Cypher	8	3316	April 3, 2019

Take the Course Then Join The Aura Agent Hackathon

Adding relationships between an array of array of objects

Related topics

Take the Course Then Join
The Aura Agent Hackathon