csv - 如何使用 CSV 字段在 LOAD 语句中定义节点标签

Question

此示例取自 https://neo4j.com/developer/guide-importing-data-and-etl/#_importing_the_data_using_cypher ”

LOAD CSV WITH HEADERS FROM "file:customers.csv" AS row
    CREATE (:Customer {companyName: row.CompanyName, customerID: row.CustomerID, fax: row.Fax, phone: row.Phone});

我想要做的是使用 CSV 文件中的一个字段来定义节点中的标签。例如:

LOAD CSV WITH HEADERS FROM "FILE:///Neo4j_AttributeProvenance.csv" AS CSVLine CREATE (q:CSVLine.NodeType { NodeID:CSVLine.NodeID, SchemaName:CSVLine.SchemaName, TableName:CSVLine.TableName, DataType:CSVLine.DataType, PreviousNodeID:CSVLine.PreviousNodeID });

Answer 1

你应该看看 APOC程序。在这种情况下，有一个程序能够根据 .csv 文件中的列值动态创建节点。语法是:

CALL apoc.create.node(['Label'], {key:value,…​})

在您的情况下，最简单的语法应该是:

CALL apoc.create.node(["' + CSVLine.NodeType + '"], {NodeID: "' + NodeID:CSVLine.NodeID + '", etc}) yield node