Skip to Content
avatar image
Former Member

BLANK FROM FLAT FILE IS TAKEN AS ? IN SAP HANA

Hello Experts,

I have been assigned a task where i have to upload a flat file into the hana system which will be later converted to a universe and then developed into a dashboard.


Now, the problem that I am facing is the excel sheet contains columns in which the fields have a space, when this is uploaded in HANA , it is getting interpreted as a '?'

I have done the setting SAP HANA -> runtime -> common -> remove the ' ?'


But still I am getting '?' in one of my fields.


This is  necessary to be eliminated because a universe will be created and thus a dashboard.


I have attached the snapshots.


Kindly help


Thanks in advance




scr1.JPG (122.5 kB)
scr2.JPG (31.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 07, 2015 at 04:08 PM

    Ok by default hana will show nulls as ? but it seems you have turned this setting off and are still seeing question marks.  This tells me that it is not truly null.  Plus seeing your screenshot shows a list of values including ?.  If it were truly null it would say 'null' in the list of distinct values.  So I think the column truly contains real question marks that were imported from your CSV.  You could either 1) massage the CSV, remove all question marks and re-import or 2) perform an update on the data something like this;

    UPDATE SCHEMA_NAME_HERE.SYSTEM_STATUS_TABLE SET T = '' WHERE T = '?'

    Hope this helps!

    -Patrick

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 07, 2015 at 05:17 PM

    Hi,

    To be sure use something like

    SELECT COUNT(*)

    FROM YOURTABLE

    WHERE T IS NULL;

    regards,

    Alan

    Add comment
    10|10000 characters needed characters exceeded