Remove Duplicate Nodes¶

Merges duplicate nodes across the entire graph that share the same id.

Priority: 0

Details¶

This is a general-purpose deduplication step that finds any nodes with matching IDs and merges them. Properties are combined and relationships are merged. IDs are normalized to lowercase.

Cypher¶

MATCH (n)
WHERE n.id IS NOT NULL
WITH toLower(n.id) AS lid, collect(n) AS ns
WHERE size(ns) > 1
UNWIND tail(ns) AS d
CALL apoc.refactor.mergeNodes([head(ns), d], {properties:'combine', mergeRels:true})
YIELD node
SET head(ns).id = lid