I'm using APOC to import the contents of an Excel file. Where I'm having issues is when a NULL value is encountered during the import. For example if the data looked like this in Excel:
NAME DATE COMPANY
WIndows 10 2015-01-01 Microsoft
Windows 7 null (empty cell) Microsoft
RHEL 6 2016-05-01 Red Hat
When parsing the file, I perform a date conversion (using date()) but it will fail due to the null value in the second entry. I've tried various conditional attempts with CASE, NOT NULL, etc., but still have issues.
Basically, if the cell does NOT have a null value then process the contents otherwise process the next cell. Do I need to do a multiple pass to make this work instead of trying to handle things on a single pass?