cancel
Showing results for 
Search instead for 
Did you mean: 

Multi-value string to list problem

I am currently stuck in this exercise: Transform Strings to Lists | GraphAcademy (neo4j.com)
I tried everything. Even I copied the exact same thing that was in the solution. Still it shows error. Can anyone help?

 

12 REPLIES 12

Leo
Node Link

The same for me. I even restarted the whole course from scratch using the provided solutions.

Leo
Node Link

Any help please ?

JohnC
Node Link

I have the same problem. I have included screenshots. The first shows the property lists and the second shows the error when I try to rerun the command.

Second screenshot.

Screenshot from 2022-09-10 16-16-15.png

Hi John,

When you run the query the first time, it will convert the string (which contains one or more items) to a list (I doubt it's actually an array). So when you run it a second time, it's not a string anymore. That's why you cannot run it twice without starting from scratch.

hey Leo,

Thanks for the reply. I posted the error to show that it already ran and that there was no longer a string to convert. I'm stuck at the same place you are. I completed all the steps but the validation fails.

- Do you know if there is a way to have someone validate our DB and tell us definitively if its a user or system error?

Hi John,

I'm afraid we are stuck. I have sent an email. Wait and see but I have limited time in my side. Hope you'll find a solution too.

quilvio
Node

i'm in the same boat. hopefully we hear something soon

m_padaria
Node

Did anyone get any help or hear back. Stuck in the same boat and have started from scratch multiple times but get stuck in the same place.

Hello all,

We made some internal changes to the Importing CSV data course that messed up the verification process.

We are working on the solution and will let you know when it has been fixed.

Elaine

The course is now fixed and imports and verifications should be all set. The only remaining code that is incorrect that we will fix tomorrow is the code in the last Challenge of the course. The loading of user rating data should be:

:auto USING PERIODIC COMMIT
LOAD CSV WITH HEADERS
FROM 'https://data.neo4j.com/importing/2-ratingData.csv'
AS row
MATCH (m:Movie {movieId: toInteger(row.movieId)})
MERGE (u:User {userId: toInteger(row.userId)})
ON CREATE SET u.name = row.name
MERGE (u)-[r:RATED]->(m)
ON CREATE SET r.rating = toInteger(row.rating),
r.timestamp = toInteger(row.timestamp)

Thank you Elaine and thanks to the Neo4j team for helping!

Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

On November 16 and 17 for 24 hours across all timezones, you’ll learn about best practices for beginners and experts alike.