Loading csv file returns error

Neo4j Graph Platform Browser
,
1

Dear Community,

I have a problem loading my CSV file, I really could use some help. This is my query

LOAD CSV WITH HEADERS FROM file:///Solucionadores15JUN.csv AS row with row where row.NomnreMostrar is not null
MERGE (s:solucionador {name:row.NombreMostrar})
MERGE (t:tipo {name:row.TipoSolucionador})
MERGE (e:experiencia {name:row.ExperienciaAcademica})
MERGE (b:biografia {name:row.Biografia})
MERGE (k:keywords {name:row.Keywords})
MERGE (i:skills {name:row.Skills})

Note that I have to load the file without the ' ' or " ", because it doesn't recognize my location otherwise, and I found the solution on the internet.

But whenever I run this, it says:

Invalid input '(': expected

(line 2, column 7 (offset: 117))
"MERGE (s:solucionador {name:row.NombreMostrar})"

2

The issue is caused by your syntax. You have to wrap the file name in quotes. It errors on parsing the next line. Try moving your 'with row' to the new line. You will see the error is not with the merge, but now with the 'with'

Let's try to solve why it can't find your csv file. Are you putting it in the database's import folder?