Can't import csv to neo4j

[maidh]

Hi,

I run query to save relationship but it shows (no changes, no records). the location_id and weather_id are both not null. Location and Weather nodes are fine. What did i do wrong here?

Thank you for your help!

[glilienfield · Accepted solution]

Are your location_id and weather_id properties stored as integers? If so, you need to conver both line.location_id and line.weather_id to integers to get the match to work. The reason is because every value is imported as a string. Use the toInteger() to convert each. 

https://neo4j.com/docs/cypher-manual/current/functions/scalar/#functions-tointeger

you can also see if the match is returning something in the subquery if your return something from the subquery. Add ‘return 1 as test’ at the end of the subquery.  It will return null if the match doesn’t return a result and the outer query will return nothing for that row as well. After making the adjustment and if you get no output the match is not matching for those lines. 

[maidh]

Thank you so much! It works well now