neo4j - match using variable and create relationship between the results of the same variable

Question

I have this relationship:

and I have built this clause:

My point is that I want now to create a relationship between 1 and 2 after this match, so instead of RETURN n.name, I would need something like: CREATE n1 -[A_RELATIONSHIP]- n2

where n1 = "Serving Gateway" and n2 = "eNode-B".

Practically saying that if those two of the same Label (NetworkFunction) match in this case (as they are both related through another node with a different label but a send or receive relationship), create a relationship called "X" between them

How can I achieve that?

Answer 1

You can collect all network functions that has a send or receive relationship with mobility management. Then for each network pairs, create that relationship (A_RELATIONSHIP). Note that I used an APOC function (apoc.coll.combinations) so ensure that this function is installed.

MATCH (n:NetworkFunction)
WHERE size((n)-[:SENDS|:RECEIVES]-(:MobilityManagement)) > 0
WITH collect(n) as allNetworkFunctions
UNWIND apoc.coll.combinations(allNetworkFunctions, 2) as network
WITH network[0] as first, network[1] as second
MERGE (first)-[:A_RELATIONSHIP]-(second)