Skip to Content
0

How to import an empty date from a CSV file?

Feb 17, 2017 at 11:10 AM

122

avatar image

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

ct.jpg (58.0 kB)
idflf.png (28.7 kB)
iffjd.jpg (93.2 kB)
10 |10000 characters needed characters left characters exceeded

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

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Benedict Venmani Felix Feb 17, 2017 at 05:43 PM
-1

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

Share
10 |10000 characters needed characters left characters exceeded
Eduardo Savoine Feb 22, 2017 at 01:21 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded