Hey ,
i am importing data from a csv file in a loop .it is taking one record in a time and importing it.
i have some dummy data in csv like /,-,'',""
how i can handle it while importing.??
GraphAcademy
CUP
Learn graphs.
Score for your country.
Represent your country in the GraphAcademy Cup.
Complete courses, earn points, and win weekly prizes.
Hey ,
i am importing data from a csv file in a loop .it is taking one record in a time and importing it.
i have some dummy data in csv like /,-,'',""
how i can handle it while importing.??
Post one line from your .csv file for testing.
Solution:
FOREACH(ignoreMe IN CASE WHEN line.x <> y THEN [1] ELSE END |
//write your code
)
Here y is equal to say "/"
I recently posted this solution to a topic "CSV column with null values"
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Import from CSV: Null Error on Non Null Value | 1 | 1076 | August 22, 2019 | |
| Can neo4j-admin import skip CSV rows with formatting errors? | 0 | 1385 | October 13, 2019 | |
| Importing CSV with Null values | 3 | 267 | May 5, 2022 | |
| Problems Importing CSV | 5 | 437 | January 24, 2022 | |
| Getting Neo.DatabaseError.General.UnknownError while loading data from csv file | 7 | 1851 | April 23, 2020 |