load csv with headers from "file:/testfile.csv" as row
FOREACH(ignoreMe IN CASE WHEN trim(row.b) = "truck" THEN [1] ELSE [] END | MERGE (p:Truck {vehicleType: row.a}))
FOREACH(ignoreMe IN CASE WHEN trim(row.b) = "car" THEN [1] ELSE [] END | MERGE (p:Car {vehicleType: row.a}))
1 回答
这个document on conditional statements有帮助 .
这是一个基于列值加载的简单示例:
数据:a,b福特,汽车雪佛兰,卡车马自达,汽车GMC,卡车F150,卡车
Cypher代码:
完成后,您将创建不同类型的节点 .