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?
Benedict Venmani Felix replied
Thanks John, for your inputs. A team mate of mine came up with an idea to load blanks.
We have to replace all null values(,,) with one blank space(, ,) and then when using the import wizard , you have to uncheck the check-box which says "Ignore leading and trailing white space(s) in file".
This would load a blank, which is not the same as null, but it works for our scenario or of course we can replace it with null in a calculated column if needed.