cancel
Showing results for 
Search instead for 
Did you mean: 

Count the number of duplicates in result

ovashape
Node

Hello community,

I am new to neo4j and I'm trying to get a list of nodes (that has not a specific relation) and count node name duplicates.

Query:

MATCH (e:ExampleNode)
WHERE NOT exists((e)-[:EXAMPLE_REL]->())
RETURN e.name as name, count(e.name) as count

Result:

name count
name1 3
name23 1
name8 4

So far so good...

Beside the name of the node I also need some more values. This value makes each result unique and returns every node separately even (if the name is the same).

Query:

MATCH (e:ExampleNode)
WHERE NOT exists((e)-[:EXAMPLE_REL]->())
RETURN e.name as name, count(e.name) as count, e.property as someValue

Result:

name count someValue
name1 1 abc
name1 1 cba
name1 1 xyz
name23 1 abc
name8 1 123
name8 1 321
name8 1 987
name8 1 789
... ... ...

But...this is the result I would like to have:

name count someValue
name1 3 abc
name1 3 cba
name1 3 xyz
name23 1 abc
name8 4 123
name8 4 321
name8 4 987
name8 4 789
... ... ...

I would like to return every node that hasn't the specific relation and count all duplicates by the name.

So, is it possible to get the result I would like to have?

1 ACCEPTED SOLUTION

Cobra
Ninja
Ninja

Hello @ovashape 🙂

MATCH (e:ExampleNode)
WHERE NOT exists((e)-[:EXAMPLE_REL]->())
WITH e.name as name, count(e.name) AS count, collect(e.property) AS values
UNWIND values AS value
RETURN name, count, value

Regards,

Cobra

View solution in original post

2 REPLIES 2

Cobra
Ninja
Ninja

Hello @ovashape 🙂

MATCH (e:ExampleNode)
WHERE NOT exists((e)-[:EXAMPLE_REL]->())
WITH e.name as name, count(e.name) AS count, collect(e.property) AS values
UNWIND values AS value
RETURN name, count, value

Regards,

Cobra

Thanks for your quick answer. This solved my problem.