Your statement can run but does not achieve the effect I want. It does not add any nodes and relationships, which confused me.
The content of the file like this:
VIN1
VIN2
ID1
ID2
43B6PK910A
(null)
(null)
(null)
L47DE59170
LA8LC2B867
(null)
15010319
L4CB162015
L0000000000
(null)
72010075
D9CB162015
FM03265775
(null)
(null)
The record of each line means that a car whose id is VIN1 hit another car whose id is VIN2. The person whose id is ID1 is the driver of the first car, and the person whose id is ID2 drove the second car when the accident happened.
There are some missing values, so i can't create any relationships based on the first row (no DRIVE and no HIT).
//Case:ID1 and ID2 are null...................line 4................
FOREACH(ignoreMe IN CASE WHEN line.VIN1 IS NOT NULL AND line.ID1 IS NULL THEN [1] ELSE END |
FOREACH(ignoreMe IN CASE WHEN line.VIN2 IS NOT NULL AND line.ID2 IS NULL THEN [1] ELSE END |