Cannot merge the following node because of null property value

[Mariana]

Hi there. This is my first time to use NEO4J Desktop. I'm trying to create a graph through an xml file with the following code:

But I got an error.

I think it's because the 'closing' has null values, however I've tried to put some queries to solve it and I couldn't.
Appreciate any suggestion.
Thank you very much.

[jackson1]

You could add a WHERE condition after your WITH aliasing

WITH ...
WHERE closing._text IS NOT NULL

[Mariana]

This happened...

[jackson1 · Accepted solution]

If you want to specify multiple conditions, you can use AND:

WHERE closing._text IS NOT NULL
AND specials._text IS NOT NULL

Neo4j Graph Database Platform

WHERE - Neo4j Cypher Manual

`WHERE` adds constraints to the patterns in a `MATCH` or `OPTIONAL MATCH` clause or filters the results of a `WITH` clause.