Cypher query to retrieve common nodes and relationships

[elaine_rosenber (Elaine Rosenberg)]

Hello,

Not sure what you mean by having the count in the same column?

You return count(distinct r) and count(distinct s) which return numbers as well as the first element of the collection collect(r). Are you saying that you want the type of the relationship as a column header?

That is not possible to do. The column headers must be specified and cannot be dynamic.

You can refer to this article for clarification:

UNWIND result as table fields

Hi, I have schema something like this (Actor)-[r:ACTED]->(Movie)-[:type]->(genre) And I tried to build query as like this MATCH (g:genre) WITH collect(g.name) as genres UNWIND genres as genre MATCH (a:Actor)->[:ACTED]->(m:Movie)-[t:type]->(g:genre{name:genre}) RETURN a.name,genre,count(t) as num So this query returns result something like this **name genre num** vijay comedy 2 vijay Action 12 Jam comedy 5 Jam Horror 15 But is there a way to convert all the genre as field…

Elaine