Skip to Content
Sep 17, 2014 at 07:51 PM

HANA Studio: Load blank values from FlatFiles



I want to load a flat file using the wizard in HANA. The file I am trying to load has blank values for a lot of fields hence I am getting the error "cannot insert NULL or update to NULL".

The thing is that the table I am loading to is replicated from ECC so all the fields have 'Not Null' flag enabled. I tried using space, escape characters etc but nothing seems to work. Can I do something to load the blanks?

Even though the 'not null' flag is enabled the data replicated from ECC has blanks. Can someone explain?