Mariana
( A84113)
November 9, 2021, 10:03am
1
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
(Jackson Zheng)
November 9, 2021, 11:25pm
2
You could add a WHERE
condition after your WITH aliasing
WITH ...
WHERE closing._text IS NOT NULL
1 Like
jackson1
(Jackson Zheng)
November 11, 2021, 10:12pm
4
If you want to specify multiple conditions, you can use AND
:
WHERE closing._text IS NOT NULL
AND specials._text IS NOT NULL
1 Like