Neo4j数据导入报null property value:
报错示例:
Cannot merge the following node because of null property value for ‘year’: (t:people {year: null})
主要原因:
说明列名中有含空值,可以 remove lines from the CSV before continuing your query:
处理举例:
LOAD CSV WITH HEADERS FROM "file:///C:/test1.csv" AS line
WITH line WHERE line.name IS NOT NULL
MERGE (n:SiteA {name: line.SiteA})
MERGE (m:SiteB {name: line.SiteB})
MERGE (n) -[:has_device_function]-> (m);