如何将apoc.load.csv与apoc.create.node结合使用

问题描述

我需要导入CSV文件并从每条记录创建一个节点.我之所以使用APOC，是因为我可以在创建节点时使用CSV文件中的列来定义每种节点类型.

I need to import a CSV file and create a node from each record. I am using APOC because supposedly I can use a column in the CSV file to define each node type as the nodes are created.

这不起作用:

CALL apoc.load.csv('FILE:///C:/Temp/Test/Test/Neo4jTest/import/Neo4j_AttributeProvenance.csv',{sep:","})  YIELD map
CALL apoc.create.node(['map.AttributeName'], {key:['map.NodeID']}) return count(*)

这是错误:

Procedure call inside a query does not support naming results implicitly (name explicitly using `YIELD` instead) (line 2, column 1 (offset: 124))
"CALL apoc.create.node(['map.AttributeName'], {key:['map.NodeID']}) return count(*)"

我也尝试过这种语法:

CALL apoc.load.csv('FILE:///C:/Temp/Test/Test/Neo4jTest/import/Neo4j_AttributeProvenance.csv',{sep:","})  YIELD map
CALL apoc.create.node(map.AttributeName, {key:map.NodeID}) return count(*)

推荐答案

可以尝试一下:

CALL apoc.load.csv('FILE:///C:/Temp/Test/Test/Neo4jTest/import/Neo4j_AttributeProvenance.csv',{sep:","})  YIELD map
CALL apoc.create.node(['map.AttributeName'], {key:['map.NodeID']}) YIELD node
RETURN count(*)

我只是在创建节点上添加YIELD内容.

I just add the YIELD stuff on the create node.

欢呼

这篇关于如何将apoc.load.csv与apoc.create.node结合使用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！