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?