I have a bunch of parts with child features. There are many versions(instances) of each part. Each instance will have a different value for each feature. I want to display each instance and it's values as a column in a table.
I can return all the Nodes and Instances with: MATCH tree = (:Node{ name: "P 1" })<-[:CHILD_OF_NODE *0..]-(c:Node) WITH tree, (c)<-[:INSTANCE_OF_NODE]-(:Instance) as instance return tree, instance
Two columns are returned. In this example both of my Instances are combined in the second column. How do I return a column for each instance?
If the graph has a hierarchical structure it might help to create a Level property in the nodes.
Then you can write cypher query and export a csv in Excel, example:
MATCH (n)-[REL]->(x) RETURN id(n)AS IDA, n.level as LevelLeft, id(REL) AS IDREL, TYPE(REL) AS RELATION , id(x) AS IDB, x.level as LevelRight
In Excel you can use a pivot table with level properties in column.
I'be been struggling with this for about 6 weeks now. Clearly l will not be able to solve this on my own.
There have been no responses and I'm not sure what to try next. Is my question not clear perhaps, or maybe this cannot be done with Neo4j?
I think I should be able to reshape the data using java script with a method in my vue form. I expect it would be ugly and break a bunch of rules, but I really don't know where to go next.
I asked a freelance developer to have a look at it and he declined stating he did not know how to solve it.
ANY comments or suggestions would be appreciated at this point.
I don't know if it's what you want but it will return the tree and a list of instances for each row, if you want one instance per row, you can remove the collect()
MATCH tree = (:Node {name: "P 1"})<-[:CHILD_OF_NODE*]-(c:Node)
WITH tree, c
MATCH (c)<-[:INSTANCE_OF_NODE]-(i:Instance)
RETURN tree, collect(i) AS instances
It is not quite what I am looking for however. The attached image is almost what I want, exept I want to break up the instance column into a column for each instance.
MATCH tree = (:Node{ name: "P 1" })<-[:CHILD_OF_NODE *0..]-(c:Node) WITH tree, (c)<-[:INSTANCE_OF_NODE]-(:Instance) as instance return tree, instance
I was able to get something that looks like what I want. However I had to manually repeat the cypher for each column. Here is the query:
MATCH tree = (:Node{ name: "Assembly" })<-[b:CHILD_OF_NODE *0..]-(c:Node)
WITH b,c, c.ID as ID, c.name as name,
apoc.text.join('001' + [rel in b | apoc.text.lpad(rel.index,3,'0')], '.') as path
with c,name,path, size(split(path,'.'))-1 as indent
WITH c, path, indent, c.name as name, (c)<-[:INSTANCE_OF_NODE]-(:Instance) as instance
order by path
return c{path, indent, name}as Tree,
last(nodes(instance[0])).value as I1,
last(nodes(instance[1])).value as I2,
last(nodes(instance[2])).value as I3,
last(nodes(instance[3])).value as I4,
last(nodes(instance[4])).value as I5,
last(nodes(instance[5])).value as I6
