the csv file contain duplicate nodes and null values . a and b are persons and there relation is c. I'm trying to get a o/p without duplication and null values and along with that i need a single node 'Gary' which comes under the header B. here is ...
i used this query,i need one more node "gary " with its property "e"load csv with headers from "file:///newtask.csv" as row
WITH row WHERE NOT row.E IS null
WITH row WHERE NOT row.A IS null
MERGE(p1:person{firstName:row.A,age:row.E})
MERGE(p2:person...
