Importing a CSV to Neo4J AuraDB workspace where there is a comma separated lists in some columns

Neo4j Graph Platform Aura & Cloud
1

I have a table with synthetic data of patents with their inventors:

Patent Assignee Inventors Cites
P001 AlphaTech John Doe, Jane Smith AP001, AP002
P002 BetaHealth Emily Johnson, Michael Brown AP003, AP004
P003 GammaFinance Sarah Davis, David Wilson AP005, AP006, AP007

I tried to import this file using the browser interface, but it does not assign different nodes for the Inventors - I would like to import this file such that for each one of the inventors specified in the Inventors column there will be a separate node - is it possible?

2

Yes it is possible. You can use the “split” function to create a list from the comma delimited list. You can either use “foreach” to loop through the list to create the nodes and relate them to the parent node, or you can “unwind” the list to create the nodes and relate them as well.

Do you have you existing script you can share?