Relate multiple columns to single column also naming relationship against associated column name

[aditya_digala]

Hi,

I have some data in the following format,

1.There are n columns with different locations.
2. Each row is associated with a unique token.

loc 1           loc 2          .....         loc n                Token
Mumbai          Maharashtra                   Dubai               qwendnj1232
Delhi           Assam                         Goa                 lkfdmglm00d
Hyderabad       Orissa                        Chennai             98ufhwjbsfhd
Pune            Kashmir                       Vizag               aisdjidsanajk89

Task

Create a relationship between Token values and remaining loc values such that, the relationship should be named after their respect loc column names.

What I tried

From little knowledge, I have about Neo4J(Still learning), I used the following code but it associates all rows to all token values via a single relationship

LOAD CSV WITH HEADERS FROM 'file:///locations.csv' as row WITH row 
WHERE row IS NOT NULL

CREATE (l:locations {name:row.name})
CREATE (t:tokens {name:row.Token})
SET l+={name:row.name}
CREATE (l) -[:RELATED_TO]->(t)

[aditya_digala]

Solved here:

Relating nodes in csv with column names in Neo4J Neo4j Graph Platform

Test this one. You also could change the batch size of the transactions by uncommenting the //OF 500 rows otherwise the defaultsize is 1000 :auto load csv with headers from "file:///locations.csv" as row with row with row call{ with row with row,keys(row) as columns merge (token:tokens {name:row.Token}) with row,columns,token unwind range(0,size(columns)) as columnIndex with row,columns[columnIndex] as columnName,token where not columnName='Token' and not r…