Skipping lines when load CSV

[p_dipietro]

I have a simple LOAD CSV
with a single MERGE statement.
My question is:
How can I skip to load an entire row depending on the value of a single field?
somethink like

SKIP if row.active = 1
Thank you

[Cobra · Accepted solution]

Hello @p.dipietro

Something like this?

LOAD CSV WITH HEADERS FROM 'file:///your_file.csv' AS row
WITH row
WHERE row.active <> 1
MERGE (:Node {name: row.name})

Regards,
Cobra