Neo4j

lipchean · 02-07-2022

Hi, The CSV shown above is the result of a manual manipulation from the original csv. I then proceed to enter the following cypher. LOAD CSV WITH HEADERS FROM 'file:///Data_3.csv' AS row MERGE (m:Module {ID: row.ID, RefBy1:COALESCE(row.RefBy1,"NA") ...

lipchean · 03-01-2022

Thanks for your very fast response @glilienfield , i'll try it out.

lipchean · 03-01-2022

hi @glilienfield To make things even more complicated, how would you utilize the 'Value' column, such that the script will return the path with the largest aggregated value (should be A > C > D, because A = 2, C = 10, D = 3 for a total of 15) Thanks...

lipchean · 02-10-2022

Thanks @glilienfield I'll try this too

lipchean · 02-08-2022

Hi @glilienfield Your solution works. I do have a follow up question, i.e. why is UNION ALL required? Is there a way where both row and reference are created from a single LOAD? Thanks

lipchean · 02-08-2022

The model should look like this:

Neo4j

User Statistics

User Activity

Multiple Nodes in 1 column as target

Re: Multiple Nodes in 1 column as target

Re: Multiple Nodes in 1 column as target

Re: Multiple Nodes in 1 column as target

Re: Multiple Nodes in 1 column as target

Re: Multiple Nodes in 1 column as target