Hi Phil, I had similar situations before and I tried many ways but nothing worked. I think LOADCSV creates nodes and relationships while looping through the data file, but they get committed to the database only at a later stage (Michael correct me if am wrong)
Actually, in your situation add a coloumn to your export file and store the sum of the line item value like amount and use this when you create a sales order node as a property. You will see same values for the last column for each custid and salesordid, but use it once when you create salesorder node. This is how I solved my cases. Second option is to create a separate .csv file with custid, salesordid, total amount. After running your existing .csv file run the second file, use MATCH/MERGE to add the totamount. -Kamal On Saturday, August 12, 2017 at 5:01:23 PM UTC-7, Phil M wrote: > > I am importing data using load CSV. My script has a Merge and "On Match > set". When I find a match, I would like to add the value from the CSV row > to a running total property. When the process ends the final value will be > the sum of previous values for each match. This possible during the load > process? > > > -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
