Hajer
June 10, 2022, 11:02pm
1
Good morning experts,
i can't see the relationship between my data, there is no error and it's mentioned no changes no records
this is my code
CREATE CONSTRAINT ON (c:LIBELLEPDT) ASSERT c.id is UNIQUE;
LOAD CSV WITH HEADERS FROM
"file:///oddobhfamm.csv" as line with line where line.id is not null
CREATE (produit:LIBELLEPDT {id: (line.LIBELLEPDT) })
MERGE (assetClass:AssetClass {name: (line.AssetClass) })
MERGE (libSocieteGestion:LibSocieteGestion {name: (line.LibSocieteGestion) })
CREATE (produit)-[:AGAINST]->(assetClass)
CREATE (libSocieteGestion)-[r:TO]->(produit);
thank u so much
Hey, to ensure you have the right file and the data looks good, run the following query. What does the output look like?
LOAD CSV WITH HEADERS FROM "file:///oddobhfamm.csv" as line
return line
limit 10
Think I know what the problem is. You have a condition for ‘line.id’ not nul, but you don’t have a column with an ‘’id’ field. Remove the following:
with line where line.id is not null
ameyasoft
June 11, 2022, 5:46am
4
Please post couple of rows from your .csv file
I was able to execute your import query with a same data file I made and it created nodes and such. What does you data file look like?
Hajer
June 11, 2022, 9:53am
9
Thanks for your response ! it's a CSV file with 2127F lines
can you see it with me we can have a call by google meet if you can?
I joined a photo of my data
Hey, to ensure you have the right file and the data looks good, run the following query. What does the output look like?
LOAD CSV WITH HEADERS FROM "file:///oddobhfamm.csv" as line
return line
limit 10
Think I know what the problem is. You have a condition for ‘line.id’ not nul, but you don’t have a column with an ‘’id’ field. Remove the following:
with line where line.id is not null
ameyasoft
June 11, 2022, 5:46am
12
Please post couple of rows from your .csv file
I was able to execute your import query with a same data file I made and it created nodes and such. What does you data file look like?
Hajer
June 11, 2022, 9:53am
17
Thanks for your response ! it's a CSV file with 2127F lines
can you see it with me we can have a call by google meet if you can?
I joined a photo of my data
Hey, to ensure you have the right file and the data looks good, run the following query. What does the output look like?
LOAD CSV WITH HEADERS FROM "file:///oddobhfamm.csv" as line
return line
limit 10
Think I know what the problem is. You have a condition for ‘line.id’ not nul, but you don’t have a column with an ‘’id’ field. Remove the following:
with line where line.id is not null
ameyasoft
June 11, 2022, 5:46am
20
Please post couple of rows from your .csv file
