cancel
Showing results for 
Search instead for 
Did you mean: 

How to import an empty date from a CSV file?

Former Member

I am importing a file with several information and I have date fields that must be empty, but I can not import into SAP HANA, is there any way to insert record with empty date?

Sorry for bad english

COLUMN TABLE

DATA INFORMATION

ERROR

nilesh_bhayani2
Explorer
0 Kudos

I am also facing same problem, if you have found any solution then could you please share it?

former_member598569
Discoverer
0 Kudos

Hi,

I am also facing same problem, if you have found any solution then could you please share it?

Thanks.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I could only import the data using SDI, which in this case allowed the empty data to be processed

BenedictV
Active Contributor
0 Kudos

Try using a single quotes for empty cells => 101,'xxx','',123.45