Is there a way to make this data import easier?

[jfcastaneda]

I am trying to make a graph data that tracks the location of vehicles and their trip number. This dataset has a pickup location and various drop-off locations. This data has maximum four drop-off locations. Is there a way to make this data import easier? Like instead of using t1, t2, t3, and t4, I should use a single variable to avoid repeating setting of properties since they have the same properties. Or a way to make the same connection from one location to another without needing to draw the entire pathway. Thank you

[clem]

Can you make it into a JSON file? I think that will simplify matters a lot. And if you don't quote the numbers in the JSON file, they will be imported as number (I believe/hope.)

See my answer here about importing a JSON file:

Creating 'Country' label nodes? Cypher

I downloaded the country-codes.json file that you mentioned. I think there is something wrong with your JSON file. It seems different than the one you pointed me at. In particular, I can't find any strings like official_name_fr or UNTERM in the the file I downloaded. I modified my settings (the second makes it more convenient) apoc.import.file.enabled=true dbms.directories.import=ABSOLUTE_IMPORT_DIRECTORY I ran: call apoc.load.json("file:///country-codes.json") yield value as countries…

[ameyasoft]

Try adding the trip_number and plate_no properties to Location nodes:
MERGE (d1:Location {name: line.dropoff_1, tripnumber: toInteger(line.trip_number, platenumber: line.vehicle_plate_no)})
 MERGE (p)-[:TRIP]->(d1)-[:TRIP]->(d2)....

[jfcastaneda]

I needed the properties to be in the relationship because nodes here are treated as actual locations. I get it though, I can set properties using map style