Skip to Content
avatar image
Former Member

How to import an empty date from a CSV file?

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 17, 2017 at 05:43 PM
    -1

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 22, 2017 at 01:21 PM

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

    Add comment
    10|10000 characters needed characters exceeded