Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.
02-10-2020 02:05 AM
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.
02-10-2020 05:16 AM
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
02-10-2020 08:01 PM
02-10-2020 08:24 PM
ahh!! it okay.. i solved this problem of mine.. i uploaded wrong file
All the sessions of the conference are now available online