Relating nodes in csv with column names in Neo4J

Neo4j Graph Platform
, , , ,
1

I have a csv file in below format,
[

enter image description here
enter image description here946×284 12.1 KB

  1. There are n location columns of various locations.
  2. There's Token column at the end where each location row is associated with a different token.

TASK

Associate each token to each location column such that the relationship is named after the column name.

Example

enter image description here

My cypher code

load csv with headers from "file:///locations.csv" as row with row where row is not null
merge (l1:locations {name:row.LOC_1})
merge (t:tokens {name:row.Token})
merge (l1) -[:LOC_1]->(t)

As you can see, This code loads each column and relates them to tokens manually which is a tedious task. In reality, there are 67 columns and doing this manually takes a lot of time.

2

What is the row attribute you have on line 9?

`aimId/structureKinematicNameId`
3

Hey,

I have a very similar problem. This is the csv data I want to load. I want to create relationships HAS_AIM between Aim (who has Id and Name, first two columns) and Exo (Liftsuit 2.0, Paexo Back, ... and all other columns that come after), but only where under the Exo the word starts with HAS_AIM. The entire word (eg HAS_AIM_nevendoel) should come as a property of the relationship.

aimId

aimName

Liftsuit 2.0

Paexo Back

CarrySuit

Laevo Flex

CareExo Lift

101

repositioning

HAS_AIM_nevendoel

HAS_AIM_nevendoel

102

repositioning lifting

HAS_AIM_hoofddoel

HAS_AIM_hoofddoel

103

repositioning lowering

HAS_AIM_nevendoel

HAS_AIM_nevendoel

HAS_AIM_hoofddoel

104

carrying

HAS_AIM_nevendoel

HAS_AIM_hoofddoel

HAS_AIM_nevendoel

105

holding

HAS_AIM_nevendoel

HAS_AIM_hoofddoel

HAS_AIM_nevendoel

106

pushing and pulling long

HAS_AIM_nevendoel

107

pushing and pulling short

HAS_AIM_hoofddoel

108

push or squeeze eg clips or plugs

HAS_AIM_nevendoel

109

power grip, pliens, contact grip

HAS_AIM_nevendoel

To do this for the first Exo (Listsuit 2.0), the working code looks like this.

LOAD CSV WITH HEADERS FROM 'file:///exo_aim.csv' AS row
MATCH (e:Exo{exoName: row.`Liftsuit 2.0`})
MATCH (a:Aim {aimId: toInteger(row.aimId)})
WHERE 
row.`Liftsuit 2.0` CONTAINS 'HAS_AIM'
MERGE (e)-[ea:HAS_AIM]->(a)
ON CREATE SET ea.aimCategory = row.`Liftsuit 2.0`;

Now to do this for a variable number of exo's that the csv file can have, I created something following your example above. It doesn't give errors, though doesnt create the relationships either.. I don't understand enough of it to find the mistake.

:auto LOAD CSV WITH HEADERS FROM 'file:///exo_aim.csv' AS row with row
With row
Call{
	With row
	With row, keys(row) as columns
	Unwind range(0,size(columns)) as columnIndex
		With row,columns[columnIndex] as columnName,columnIndex
		Where row[columnIndex] CONTAINS 'HAS_AIM'
        Match (a:Aim {aimId: toInteger(row.`aimId/structureKinematicNameId`)})
		Match (e:Exo {exoName: columnName})
		With row,a,columnIndex,e
		Merge (e)-[rel:HAS_AIM]->(a)
		On create set rel.aimCategory = row[columnIndex] 
		Return rel
}  IN TRANSACTIONS
Return count(rel)

Thanks for the help !

4

That should have been aimId. I simplified the terminology for purpose of clarity of the question, but forgot this one sorry :thinking:. The question stays the same :blush: