# Strange error using cypher with LOAD CSV

**URL:** https://community.neo4j.com/t/strange-error-using-cypher-with-load-csv/41072
**Category:** Import / Export
**Created:** [July 8, 2021, 2:20pm UTC](https://community.neo4j.com/t/strange-error-using-cypher-with-load-csv/41072 "2021-07-08T14:20:40Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![p.dipietro](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/p.dipietro/32/19019_2.png) [@p.dipietro](https://community.neo4j.com/u/p.dipietro)
#### Post date: [July 8, 2021, 2:20pm UTC](https://community.neo4j.com/t/strange-error-using-cypher-with-load-csv/41072/1 "2021-07-08T14:20:40Z")

</div>

Neo4j community edition 4.0.1 Running on Ubunto 20.04.2 LTS

The following is the starting part of a cypher query

> LOAD CSV WITH HEADERS  
> FROM 'file:///xxx.csv'  
> as row  
> FIELDTERMINATOR ';'
> 
> WITH row, trim(row.Denominazione) as denominazione  
> WHERE row.Denominazione \<\> "" and row.Product \<\> ""

And these are the headers of the imported file:

> Product Code;Product;Annata;Formato;Prezzo;Tipologia;Denominazione;Produttore;Regione

As you can see, in the headers there are two fields named Product and Denominazione, and in the query I try to use them.

The query returns the following error (but also a warning with a yellow triangle along the line) telling me:

> The provided property key is not in the database  
> One of the property names in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing property name is: Denominazione)  
> WITH row, trim(row.Denominazione) as denominazione  
> ^  
> The provided property key is not in the database  
> One of the property names in your query is not available in the database, make sure you didn't misspell it or that the label is available when you run this statement in your application (the missing property name is: Product)  
> WHERE row.Denominazione \<\> "" and row.Product \<\> ""

The two fields are not into the database, because they are into the file to be imported!!!!

Have you got any suggestions?

Thank you

---

<div class="post-metadata">

### Author: ![Joel](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/joel/32/17191_2.png) [@Joel](https://community.neo4j.com/u/Joel)
#### Post date: [July 9, 2021, 5:23pm UTC](https://community.neo4j.com/t/strange-error-using-cypher-with-load-csv/41072/2 "2021-07-09T17:23:46Z")

</div>

could you run this query to show the headers and let us know what you see? Just to double check,

```auto
LOAD CSV WITH HEADERS
FROM 'file:///xxx.csv'
as row
FIELDTERMINATOR ';'
WITH row LIMIT 1 
RETURN keys(row);

```

Reference: [How do I view the column headers of a CSV file with LOAD CSV - Knowledge Base](https://neo4j.com/developer/kb/how-do-i-view-the-column-headers-of-a-csv-file-with-load-csv/)

Note: it is _extremely_ rare but technically speaking there could be a non-printable character in the header line in the csv file

---

<div class="post-metadata">

### Author: ![p.dipietro](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/p.dipietro/32/19019_2.png) [@p.dipietro](https://community.neo4j.com/u/p.dipietro)
#### Post date: [July 10, 2021, 5:37pm UTC](https://community.neo4j.com/t/strange-error-using-cypher-with-load-csv/41072/3 "2021-07-10T17:37:40Z")

</div>

Here is the result:

keys(row)  
1 ["Availability", "Annata", "Regione", "Categories", "Product Code", "Product", "Shipping Cost", "Formato", "Tipologia", "URL Prodotto", "Prezzo", "Vitigno", "Produttore", "Denominazione", "URL Immagine"]

As you can see, it looks clean!

---

<div class="post-metadata">

### Author: ![omerule](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/omerule/32/784_2.png) [@omerule](https://community.neo4j.com/u/omerule)
#### Post date: [July 11, 2021, 6:37pm UTC](https://community.neo4j.com/t/strange-error-using-cypher-with-load-csv/41072/4 "2021-07-11T18:37:53Z")

</div>

You could try backticks (`) with column name contain spaces " " something like:  
Row.`URL Immagine`

Yours Kindly Omer

---

<div class="post-metadata">

### Author: ![p.dipietro](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/p.dipietro/32/19019_2.png) [@p.dipietro](https://community.neo4j.com/u/p.dipietro)
#### Post date: [July 12, 2021, 7:56am UTC](https://community.neo4j.com/t/strange-error-using-cypher-with-load-csv/41072/5 "2021-07-12T07:56:52Z")

</div>

yes, I used backtick. The problem is with the row.Denominazione and row.Product that don't need backtick.

---

<div class="post-metadata">

### Author: ![ameyasoft](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/ameyasoft/32/32639_2.png) [@ameyasoft](https://community.neo4j.com/u/ameyasoft)
#### Post date: [July 12, 2021, 11:38pm UTC](https://community.neo4j.com/t/strange-error-using-cypher-with-load-csv/41072/6 "2021-07-12T23:38:59Z")

</div>

Please post one row of data (with headers) from your .csv file. Looks like there is some mismatch somewhere.

---

<div class="post-metadata">

### Author: ![p.dipietro](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/p.dipietro/32/19019_2.png) [@p.dipietro](https://community.neo4j.com/u/p.dipietro)
#### Post date: [July 14, 2021, 6:27pm UTC](https://community.neo4j.com/t/strange-error-using-cypher-with-load-csv/41072/7 "2021-07-14T18:27:09Z")

</div>

> `Product Code;Product;Annata;Formato;Prezzo;Tipologia;Denominazione;Produttore;Regione;URL Immagine;URL Prodotto;Vitigno;Availability;Categories;Shipping Cost`

> `12;Baladin Isaac Blanche 75cl;;cl.75;880;Birra;;Baladin;;https://www.bernabei.it/media/catalog/product/l/_/l_12.png;http://www.bernabei.it/baladin-isaac-blanche-75-cl;;in stock;Birre;490`

**The problem has been solved moving to neo4j 4.3.2 ;-)**
