Only use the ID and filter out the null names or ids USING PERIODIC COMMIT LOAD CSV WITH HEADERS FROM "file:///C:/Users/user/ Documents/NEWDATANEO4J/myfile.csv" AS line WITH line where not line.ID_Actor is null MERGE (a:Actor{id:line.ID_Actor}) ON CREATE SET a.name=line.NAME_ACTOR
Please join community.neo4j.com and ask there in the cypher category. On Mon, Aug 20, 2018 at 3:34 PM, Rhianna Tomlinson <rhiannajayn...@gmail.com > wrote: > Have you tried removing the blank lines in your CSV? > > > On Sunday, 5 August 2018 16:35:53 UTC+1, Youssef Mourchid wrote: >> >> Hi, >> >> when I was working in the previous version of neo4j (my actual version is >> 3.2.5) everything was ok, when I want to load my csv file I use this >> command: >> >> USING PERIODIC COMMIT >> LOAD CSV WITH HEADERS FROM >> "file:///C:/Users/user/Documents/NEWDATANEO4J/myfile.csv" >> AS line >> MERGE (a:Actor{id_actor:line.ID_Actor,name_actor:toString(line. >> NAME_ACTOR)}) >> >> but now after upgrading my neo4j version, it shows me the error " >> Neo.ClientError.Statement.SemanticError: Cannot merge node using null >> property value for id_actor" >> >> my csv file is like that: >> >> >> <https://lh3.googleusercontent.com/-Q5_GHpgNUrQ/W2cY-tpb1TI/AAAAAAAAApc/MNfVVxpRHwQ7PZ98d6jjvvpszbZspIFkgCLcBGAs/s1600/error.JPG> >> >> >> >> >> >> >> if anyone can help me with that, I would be very thankful. >> > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to neo4j+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.