How to import NULL values

[TornadoJoe]

Hi there,
I try to import the following:

Im having a hard time to just having the "name" displayed without using coalesce as a placeholder or skipping rows with a where clause: WITH row WHERE row.country IS NOT NULL.

I´m stuck at this. Maybe someone has an idea.

LOAD CSV WITH HEADERS FROM 'file:///csv/organization.csv' AS row
MERGE (n:Organization {
abbreviation: row.abbreviation,
name: row.name,
city: row.city,
country: row.country,
province: row.province,
established: datetime(replace(row.established, '-', '') + 'T00:00:00')
});

[joshcornejo]

Something like this:

LOAD CSV WITH HEADERS FROM 'file:///csv/organization.csv'' AS row
CREATE (n:Node)
SET n.property1 = CASE WHEN row.column1 IS NOT NULL AND row.column1 <> '' THEN row.column1 ELSE NULL END,
    n.property2 = CASE WHEN row.column2 IS NOT NULL AND row.column2 <> '' THEN row.column2 ELSE NULL END