Extract list of Nodes and Labels from path

[marcos.stival]

@mdfrenchman

MATCH p = (n:Client)-[r:PARENT_OF*]->(t:Client) WHERE n.Code="MYCODE" // nodes(p) is an array of arrays. the reduce is similar to a flat function. WITH reduce(output = , n IN nodes(p) | output + n ) as nodeCollection // here we take the single row of the flattened array and pivot it to rows. UNWIND nodeCollection as client // once we have each client in it's own row, then we call labels // Also don't forget the distinct! // Remember the arrays simply flatten out each path, 2 of your nodes show up in multiple paths. RETURN distinct client, labels(client)

Oh my god Mike, thanks for your reply it works like a charm!
I have yet to understand how flat functions works and the syntax for the reduce function too but for the sake of the query I think I get it.

Thanks again.
Have a very nice day!