Neo4j - How to display a graph of Nodes connected to properties of related nodes

Question

I have Nodes Customer and Product - with a directed relationship TRANSACTION from Customer to Product. Product has the property category.

Is it possible to display all the Customers connected to all the categories which they have bought? As though the categories were a node rather than a property.

score 1 · Accepted Answer · answered Jan 15 '21 at 07:25

1

You can use APOC Virtual Nodes and Relationships to display such graph :

MATCH (n:Product)<-[:TRANSACTION]-(c:Customer)
WITH n.category AS category, c, count(*) AS numberOfPurchases
WITH 
apoc.create.vNode(['Category'], {name: category}) AS catNode,
c,
numberOfPurchases
RETURN catNode, c, 
apoc.create.vRelationship(c, 'PURCHASED_IN_CATEGORY', {amount: numberOfPurchases}, catNode) AS rel

answered Jan 15 '21 at 07:25

Christophe Willemsen

19,399
2
29
36

Brilliant, this works! I had to add a WHERE clause to filter out products with no category. – D10001 Jan 15 '21 at 09:45
Does not work in neo4j Bloom however, maybe because it limits the search set? – D10001 Jan 15 '21 at 09:50
No idea for Bloom, I'll ask – Christophe Willemsen Jan 15 '21 at 13:11

Neo4j - How to display a graph of Nodes connected to properties of related nodes

1 Answers1