Files missing about neo4j-complaints HOT 6 CLOSED

Yeah, this repo accompanies a video where I create those files. I'll make some changes to this repo so that it can stand alone.

I'll try to recreate the .cql crash.

from neo4j-complaints.

I watched the webinar. Very very useful, thanks. I think the problem is (with the latest csv file) that some of the Issues are blanks, so MERGE fails. You are addressing this problem with subproducts and subissues by composing new files. However I'd like to be able to do this on fly. Examine the row and call merge ONLY if particular column is not null. I know I can do this with WHERE clause after Load CSV, but this is not good enough. Could you maybe suggest the way to do that? Thanks

from neo4j-complaints.

What's wrong with doing it in the WHERE clause? That's the change I was going to make.

from neo4j-complaints.

Only that you need to do LOAD CSV multiple times for each of the columns you want to merge and where you expect empty values. What would be good, I think, is to do Merge(s) with condition (if not empty) within the single row read. I found FOREACH trick by Marak Needham explaining this: http://www.markhneedham.com/blog/2014/08/22/neo4j-load-csv-handling-empty-columns

from neo4j-complaints.

Yes, then you would need to use the FOREACH hack, unfortunately. I purposely avoided that in the webinar because it's pretty ugly.

from neo4j-complaints.

I've updated the repository to use Consumer_Complaints.csv across all the import queries. Also, I'm guessing your exception was raised because LOAD_CSV.cql requires the missing files you were asking about.

from neo4j-complaints.