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.

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