BLANK FROM FLAT FILE IS TAKEN AS ? IN SAP HANA
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.
Thanks in advance