Data Type Not Coming Correct in SAP

[sumitk]

Hello,

In my SAP HANA table AGR_1251, the field LOW's data type is set as CHAR. When I check the value in SAP HANA, it appears as 001. However, when I extract this table into QlikSense, it converts it to a number, and the value appears as 01.

I do not want it to be converted to a number; I want the value to remain as a character in QlikSense.

Please suggest how I can address this issue.

Thank you in advance.

[rubenmarin · Accepted solution]

Hi, in the load section you can use the Text() function to keep it as character:

LOAD Text(FieldName) as FieldName...

[sumitk]

Hi,

You are saying like this

LOAD Text(Low) as Low

Select Low from AGR_1251;

Correct?

[rubenmarin]

Hi, yes, that's the idea. It doesn't works with that?

[sumitk]

Hi,

Yes it's working, Thanks for your support.