Hello all,
I have a node and relationship csv. In relationship, I have a column where I need to split the column on a pipe. I tried using --array-delimiter = '|' but It doesn't split the data. My data looks like
I used the code neo4j-admin import --verbose --ignore-extra-columns=true --array-delimiter "|" --nodes C:/Users/Sam/Documents/node.csv --relationships C:/Users/Sam/Documents/rel.csv.
LOAD CSV WITH HEADERS FROM "file:///node.csv" AS row
CREATE (node:Label {data: split(row.data, '|')} )
You might have to do a second pass to create the relationships, which will require something like a MATCH for the node and then separate CREATE/MERGE for the relationship.