I have a spreadsheet where certain columns are null (for instance, if this
was a list of businesses, some of the addresses or fax number cells will be
blank)
I want to import this using the CSV Loader. This is simplified example of
what I have:
LOAD CSV WITH HEADERS FROM "file:/C:/myfile.csv" as line
MERGE (b:business {name: line.name})
MERGE (a:address {address: line.address})
CREATE (b)-[:HAS_ADDRESS]->a
The problem is that if the address was null, all companies with null
addresses get connected to the same empty address node 'a'.
How can I incorporate an "is not null" type of condition on the creation of
the relation?
Thanks,
Dan
--
You received this message because you are subscribed to the Google Groups
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
