I am trying to load data using the load csv. syntax might be wrong here.
<USING PERIODIC COMMIT 100 LOAD CSV WITH HEADERS FROM "file:///myfile.csv"
as eachline FIELDTERMINATOR ,
"MATCH(r:Record) where r.Id contains eachline.Id
set r.Name=eachline.Id , r.EmailId=eachline.email , r.lastName=eachline.id />
Sample query above.
Here i want to SET/update the e.EmailId only if the value is present.
it may happen that email is updated and it is not present in the record next time when csv is generated. in that case i want to ignore the record and not set with empty field and update other fields.
could the ignoreme be used here?