csv - Neo4j CSV 文件加载空单元格

Question

我正在将一个基本的 CSV 文件加载到 Neo4j 数据库中，该数据库有两列 -“名称”和“属性”。名称列始终具有值，“属性”列可以具有值或空格。我希望值与关系“property1”链接。

我正在使用此代码:

LOAD CSV WITH HEADERS FROM 'file:///fileName.csv' AS line
MERGE (Test_Document:A {name: line.name})
WITH line, Test_Document 
FOREACH (x IN CASE WHEN line.property IS NULL THEN [] ELSE [1] END |
  MERGE (Properties:B {property1: line.property})
WITH Test_Document, Properties
FOREACH (y IN CASE WHEN Properties IS NULL THEN [] ELSE [1] END |
  MERGE (Test_Document)-[:property1]->(Properties))

我收到一条错误消息:

Unexpected end of input: expected whitespace, LOAD CSV, START, MATCH, UNWIND, MERGE, CREATE, SET, DELETE, REMOVE, FOREACH, WITH, CALL, RETURN or ')' (line 8, column 54 (offset: 423))
"  MERGE (Test_Document)-[:property1]->(Properties))"

如有任何帮助，我们将不胜感激。

Answer 1

您的查询有两个问题:

1. 第 5 行缺少右括号
2. Properties 不在第二个 FOREACH 的范围内，因为它是在前一个 FOREACH 中声明的(在 FOREACH 中声明的别名) 的范围仅限于该 FOREACH 子句)

试试这个:

LOAD CSV WITH HEADERS FROM 'file:///fileName.csv' AS line
MERGE (Test_Document:A {name: line.name})
WITH line, Test_Document 
FOREACH (x IN CASE WHEN line.property IS NULL THEN [] ELSE [1] END |
  MERGE (Properties:B {property1: line.property})
  MERGE (Test_Document)-[:property1]->(Properties)
)