cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

Neo.ClientError.Statement.SemanticError Cannot merge node using null property value for Month

Hi i am new to neo4j. I would like to create 3 nodes using my csv data. Below is my code:

LOAD CSV WITH HEADERS FROM "file:///errorlog.csv" AS row

MERGE (d:DateTime {Name:row.Date, Month:row.Month, Day:row.Day, Time:row.Time, Year:row.Year})
MERGE (l:LogLevel {Name:row.LogLevel})
MERGE (m:LogMessage {Name:row.LogMessage})
MERGE (d)-[:HAVE]->(l)
MERGE(m) <-[:FROM] - (l);

But I got back an error of Neo.ClientError.Statement.SemanticError
Cannot merge node using null property value for Month. However, my Month had no null value.

3 REPLIES 3

Hi elainerawks,

welcome to the Neo4j community!
Could you please upload your csv file? Without it it is difficult to rebuild the error.
I often got this error when my csv file was not comma-separated but semicolon-separated. Might that be true for yours aswell?

Regards,
Elena

Hi, it is comma-separated. I only able to upload txt file.. I not too sure how to upload my csv here

errorlog.txt (709.9 KB)

ahh!! it okay.. i solved this problem of mine.. i uploaded wrong file