Skip to Content
0

File import into HANA when certain column values are blank

Jul 28, 2017 at 06:23 AM

31

avatar image
Former Member

I have flat file where certain values are blank. So while importing the file into HANA I want them to be considered as null and not blank. File is of csv format.

So could you please suggest on this anyone?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Aug 03, 2017 at 07:53 PM
0

It depends on value in column of CSV file and Table definition.

Example : If value is column of CSV file is blank and In table definition null values are accepted then value will store as null/ ?

If not then default value will be stored as per definition.

Share
10 |10000 characters needed characters left characters exceeded