How to combine refactor clonesNodes with rename.label?

Neo4j Graph Platform Procedures & APOC
, ,
1

How do I do the following in one cypher query?

  1. match a set of nodes
  2. clone them and their relationships
  3. change the label on the cloned nodes

I tried various versions of the code below but only the clone is created; the label is not renamed.
The code below is for one node with id = 'abc' to validate the procedures.

MATCH (n:OldLabel {id:'abc'})
WITH collect(n) as nodes
CALL apoc.refactor.cloneNodes(nodes,True) YIELD output as c
WITH collect(c) as clones
CALL apoc.refactor.rename.label("OldLabel","NewLabel",clones)
YIELD batches as b
RETURN clones

Running them separately works.
The end goal is to remove the filter on id(n) <> 123 and have both calls execute against all nodes with OldLabel. i.e. create a set of OldLabel, clone and rename them.

MATCH (n:OldLabel {id:'abc'})
WITH collect(n) as nodes
CALL apoc.refactor.cloneNodes(nodes,True) YIELD output as c
return c

if 123 is the original node, rename all others.

MATCH (n:OldLabel {id:'abc'})
WHERE id(n) <> 123
WITH collect(n) as clones
CALL apoc.refactor.rename.label("OldLabel","NewLabel",clones)
YIELD batches as b
RETURN clones
2

@czepeda
This is very weird. I think it's a apoc.refactor.rename.label bug.

Anyway, you could execute this statement as a workaround (using the apoc.periodic.iterate to batch results):

MATCH (n:OldLabel {id:'abc'})
WITH collect(n) as nodes
CALL apoc.refactor.cloneNodes(nodes,true) YIELD output as c WITH c
CALL apoc.periodic.iterate(
    "match (c) return id(c) as id", 
    "MATCH (n) WHERE id(n) = id set n:NewLabel remove n:OldLabel",   // change labels
    {params: {c: c}}
)
YIELD batches
RETURN batches

If you don't want to use batches, you can just execute:

MATCH (n:OldLabel {id:'aaa'})
WITH collect(n) as nodes
CALL apoc.refactor.cloneNodes(nodes,true) YIELD output as c
WITH c
SET c:NewLabel remove c:OldLabel // change labels
RETURN c
3

Thank you, Guiseppe!