Hi, I'm trying to solve a problem of having files that doesn't have the same name convention for the headers. For example, the user wrote a column name in two ways: SNIRH
and snirh
. It's possible to convert the property label to something uniform using toLower()?
The solution that I'm approaching is testing those possibilities, but it's not optimal and doesn't solve the problem for all cases.
WITH $json as list
UNWIND list as obj
MATCH (n:QualityStation) WHERE (obj.SNIRH CONTAINS n.snirh) OR (obj.snirh CONTAINS n.snirh) OR (n.id = obj.id)
...
At the same topic, it's possible on SET
to load all properties except some in especific? My current version add all, but the problem starts again with the name convention. The file can have either Name
or name
MERGE (f:GISFeature {Name: features.properties.Name, type: features.type})
SET f += features.properties