Neo4j

pw6163 · 07-08-2021

I'm importing a CSV which includes vehicle details. Here in Australia some classes of vehicle do not need to have registration, and the CSV has a blank field for these. I'd like to generate an "artificial" rego for these rows with a pattern like "UNR...

pw6163 · 07-14-2021

Wow! Thank you for that - there's a lot I haven't come across before in that answer. It's helpful to see what looks to me to be a sophisticated solution. Cypher is clearly more able that I'd realised ! Paul

pw6163 · 07-11-2021

Thanks, that's the approach I'll go with for the moment. I'm trying to avoid pre-processing the CSV for a couple of reasons - the more capability I can show from Cypher the more credibility neo4j has as a useful tool, but also we have a strong prefer...

pw6163 · 07-10-2021

@Cobra: Sure, here's a sample of the kind of data I'm using: DATE_RECEIVED,REGO,VEHICLE_YEAR,VEHICLE_DESCRIPTION,CLIENT 12/03/2020,1eid123,2010,Landrover 90,Insurer 1 14/03/2020,,2009,Baler,Insurer 2 27/06/2020,abc987,2019,BMW 320i,Insurer 1 30/06/20...

pw6163 · 07-10-2021

@Cobra: I thought about using something like a UUID although I hadn't looked for that functionality in detail. Unfortunately that's going to create a rego that's too long to be believable - that sounds like a small thing, and if neo4j was the only da...

pw6163 · 07-10-2021

Thanks. I've copied the suggestion from the Cypher guide and re-read the import file a number of times to get different clusters of nodes (i.e. once per label). The vehicle details are the only one where I need to artificially create missing data. In...

Neo4j

User Statistics

User Activity

Incrementing variables in Cypher?

Re: Incrementing variables in Cypher?

Re: Incrementing variables in Cypher?

Re: Incrementing variables in Cypher?

Re: Incrementing variables in Cypher?

Re: Incrementing variables in Cypher?