Remove null s from result

General Newbie Questions
,
1

I've created a query in neo4j :

MATCH (x:Node)-[r*1..2]->(y:Node) 
WITH x AS x, SIZE(COLLECT(DISTINCT y)) AS y
WITH CASE
	WHEN y=10 THEN x.target
END AS l
return l AS target

But returns something like :

target
____
null
null
"test1"
null
null
"tes56"
...

What I want is :

target
____
"test1"
"tes56"
...

no null in entries. How can I achieve this ?

in short remove null row from where queries

2

Hello @maifeeulasad and welcome to the Neo4j community :slight_smile:

MATCH (x:Node)-[r*1..2]->(y:Node) 
WITH x AS x, size(collect(DISTINCT y)) AS y
WITH CASE WHEN y=10 THEN x.target END AS target
WHERE target IS NOT null
RETURN target

Regards,
Cobra