BLANK FROM FLAT FILE IS TAKEN AS ? IN SAP HANA

[Former Member]

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

[alanmcshane]

Hi,

To be sure use something like

SELECT COUNT(*)

FROM YOURTABLE

WHERE T IS NULL;

regards,

Alan

[patrickbachmann]

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