I successfully created the nodes, but I was trying to create relationships between these nodes with the relationship type also to be retrieved from the csv on the run.
The query I was trying:
LOAD CSV FROM 'file:C:/temp.csv' AS line
MATCH (node1:Keyword {name: line[0]})
MATCH (node2:Keyword {name: line[1]})
CREATE (node1)-[:line[3] {weight: line[2]}]->(node2)
As you can see from the query I was trying to that pass on line[3] to be the relationship type retrieved dynamically from csv for every row instead of an unique predefined identifier.
This is the error I got:
Neo.ClientError.Statement.InvalidSyntax
Invalid input '[': expected an identifier character, whitespace, '|', a length specification, a property map or ']' (line 1, column 192 (offset: 191)) "LOAD CSV FROM 'file:C:/temp.csv' AS line MATCH (node1:Keyword {name: line[0]}) MATCH (node2:Keyword {name: line[1]}) CREATE (node1)-[:line[3] {weight: line[2]}]->(node2)"
And the (^) is placed under the '[' symbol in line[3] by neo4j compiler.
In my previous experiments I placed this line[3] as another relationship property along with the weight and it worked, but now while trying to store it as relationship type itself I hit this roadblock.
Am I doing something wrong or is there some other way to do it?
Any help is appreciated.
Thanks, Siva