Group NODES by CONTAINS

Neo4j Graph Platform Cypher
#1 
MATCH (l:WORD)<--(k:SENTENCE)
WITH l
MATCH (l)-[*]-(n:SENTENCE)
WHERE n.name CONTAINS l.name
WITH n.name AS NodeContainingTheWords, l.name AS TheWord
RETURN NodeContainingTheWords, TheWord

Returns the following

image
image3253×1045 208 KB

I want to group 1 and 2 so that I can ORDER BY which :SENTENCE CONTAINS the most WORDS

#2

Hello @VilladsClaes :slight_smile:

You can aggregate by words or sentences with collect():

RETURN NodeContainingTheWords, collect(TheWord) AS words

Or

RETURN TheWord, collect(NodeContainingTheWords) AS sentences

Regards,
Cobra

1 Like