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 ';'
match (d:Day {name:"Lundi"})
where row.Lundi = "x"
with d,row.Serveur as serverName, collect(row.Script) as scripts
match (s:Serveur {name:serverName})
merge (d)-[:PROCESS]->(s)
with s,head(scripts) as first, scripts, size(scripts) as size
match (scr1:Script {name: first})
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
MATCH (script:Script {name: scripts[0]})
CREATE (s)-[:EXECUTE]->(script)
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].
For more options, visit https://groups.google.com/d/optout.
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
