you need to have the nodes for days, servers, scripts etc. before otherwise use merge
> Am 16.05.2015 um 23:21 schrieb [email protected]: > > Hi Michael, > > Thanks for your answer, i tried to followyour solution but without success. > > LOAD CSV WITH HEADERS FROM 'file:c:/Users/Fred/Desktop/cgp2.csv' AS row > FIELDTERMINATOR ';' > merge (d:Day {name:"Lundi"}) > where row.Lundi = "x" > with d,row.Serveur as serverName, collect(row.Script) as scripts > merge (s:Serveur {name:serverName}) > merge (d)-[:PROCESS]->(s) > with s, scripts, size(scripts) as size > merge (scr1:Script {name: scripts[0]}) > create (s)-[:EXECUTION]->(scr1) > FOREACH (idx in range(0,size-2) | > MERGE (s1:Script {name:scripts[idx]}) > MERGE (s2:Script {name:scripts[idx+1]}) > CREATE (s1)-[:AFTER]->(s2)) > WITH scripts, s > > When i do a match n return n it returns nothing. > > Thanks for your help. > > Best regards, > > Fred > > Le vendredi 15 mai 2015 11:49:23 UTC+2, [email protected] a écrit : > Hi all, > > I've got .csv file with servers and scripts and days > > Serveur Script Lundi Mardi Samedi > AALTO Script1 x x x > AALTO Script2 x x > AALTO Script3 x > AALTO Script4 x > ABBOTT Script5 x x > ABBOTT Script6 x > ABBOTT Script7 x > ABBOUD Script8 x x > ABBOUD Script9 x x > ABBOUD Script10 x x > ABBOUD Script11 x x > ABBOUD Script12 x x > > And i'd like to create following relationships : > > Lundi-[:Process]->(AALTO)-[:Execution]->(Script1)-[:Puis]->(Script2)-[:Puis]->(Script4) > Lundi-[:Process]->(ABBOTT)-[:Execution]->(Script6) > Lundi-[:Process]->(ABBOUD)-[:Execution]->(Script8)-[:Puis]->(Script9)-[:Puis]->(Script10) > > And so on for Mardi and Samedi > > Thanks a lot for your help. > > Fred > > -- > 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] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > <cgp2.csv> -- 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.
