As you can see in your file your ID is containing a tab character in front
" D000001"
So you would have to clean up your CSV or use the trim() function, like this
> LOAD CSV WITH HEADERS FROM "filepath" AS csvLine
> CREATE (d:Descriptor { descID: trim(csvLine.DescriptorUI), descName:
> csvLine.DescriptorName, treeNum: csvLine.TreeNumber })
> Am 10.02.2015 um 22:59 schrieb Rohit Ingle <[email protected]>:
>
> Hi everyone,
>
> I am a beginner in Neo4j and working on importing data from a CSV file in
> Neo4j using Cypher.
>
> The columns of the csv correspond to the properties I want each node to have.
> (DescriptorUI, DescriptorName and TreeNumber)
>
> I used the following query to successfully import the data into Neo4j:
> LOAD CSV WITH HEADERS FROM "filepath" AS csvLine
> CREATE (d:Descriptor { descID: csvLine.DescriptorUI, descName:
> csvLine.DescriptorName, treeNum: csvLine.TreeNumber })
>
> This created a set of nodes equal to the number of rows. However when I try
> to search for the node "D000001" using the query - match n where n.descID =
> "D000001" return n, it returns 0 results.
> All the other nodes can be searched properly using the above query (Problem
> only with D000001).
>
> I am able to search for that node using the descName property. ( match n
> where n.descName= "Calcimycin" )
> Maybe I am missing something very silly here, but I was not able to find a
> logical reason for this behaviour. I have attached the file I am using to
> this message.
>
> Thanks,
> Rohit Ingle
>
>
> --
> 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]
> <mailto:[email protected]>.
> For more options, visit https://groups.google.com/d/optout
> <https://groups.google.com/d/optout>.
> <CSV-1.csv>
--
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.
