cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot merge the following node because of null property

mauuuuu5
Node Clone

Hi everyone I was trying to load the Zachary's karate club dataset, which can be found here. The file "zkc.graph" was copied in the import folder and I ran this code:

LOAD CSV FROM "file:///zkc.graph" AS row
  FIELDTERMINATOR " "
  MERGE (p:Person {pId: toInteger(row[0]) + 1})
  MERGE (q:Person {pId: toInteger(row[1]) + 1})
  MERGE (p)-[:LINKED_TO]->(q)

but unfortunately I have this error mesage

Cannot merge the following node because of null property value for 'pId': (:Person {pId: null}) (Failure when processing file '/C:/Users/MAURICIO/AppData/Local/Neo4j/Relate/Data/dbmss/dbms-238a0987-27b1-43d4-9136-a2d5a502f208/import/zkc.graph' on line 1.)

The dataset header is as follows:

2X_b_b9be220da139f962ba9032c1a32243212522d80b.png

  • neo4j version: Neo4j 4.2.0
  • desktop version: Version: 1.3.11
  • browser version: Chrome version 86.0.4240.198 (Build oficial) (64 bits)

Thank you

Mau

2 REPLIES 2

ameyasoft
Graph Maven

There is no header for this file. Just delete the first row with that header or start from row 2.

Hi thank you for your reply, I basically copied and pasted the information into a CSV file and executed the same code as above but just changing the extension to CSV.

2X_9_94bb3cab234b3dfacbd22a1ae97a10961a16b000.jpeg

Thank you

Mau