Duplicate nodes merges everything

[vence_andersen1]

Hie,

I am having a csv like (a sample created to state my data)

so on loading it into neo4j i got

Here just becasue the 4th node(or by image id 12) is same for both the paths they've merged into one. Can I avoid this, since nodes connected from 4th node are unique to thier paths.

Thanks in advance.

[david_allen]

Post the MERGE cypher you're using to create this.

A common slight error with merge is that it merges the full unique pattern. So if you're merging longer paths, you can end up with duplicates if sub-paths (like 12 to 7 here) occur in multiple different longer paths.

A solution is to break down your load into a set of pairwise relationships; think about always merging (a)-[:r]->(b) and don't write merges like (:a)-[:r]->(b)-[:r]->(c) because it could duplicate the a-b relationship

[vence_andersen1]

The Cypher query i used

As I was dealing with dynamic relationship I had to go with apoc for creating the relationship.

[vence_andersen1]

Using create instead of merge helped me solve the issue, but now i have unique nodes for all like

Since the path is same except for the last node can I merge them?