I want to import relationships from a CSV file. I have extracted the two relevant columns (there are more):
I have already created the nodes that correspond to the first and second columns ('Associations
and 'tags'), and these columns contain identifiers of these two kind of nodes.
Examples of relationships:
ArochaCH --> #chrétiens
Alliancesudfr --> #à_gauche, #activistes
(some Associations have several tags!)
Why this layout with blanks ? The blank cells in the first column make it more readable for humans and the fact of using different cells for each tag, rather than a comma-separated list, allows for a validation filter in google sheets (the source).
However, I do not know how to import these relationships successfully with LOAD CSV, row by row, because of the blank cells.
-> Perhaps there is a neo4j command to indicate that the value of blank cells is the same as the first-non-null value above (e.g., cell 7 should be understood as "Alliancesudfr")
-> Perhaps there is a more standard format for the EXCEL, which is user-readable and robust (with validation)
- neo4j version: 3.5
Many thanks in advance!