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

Neo4j Graph Platform
1

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.

2

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

3

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)

4

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