Qliksense not printing correctly

[Sneha1]

Hello All,

I have tried already text(field) to retain number with leading zeros  and without zeros but still qliksense is not printing it correctly. I cannot see the data in sheet correctly.

my code is as below

PS_Z_RW_AFFILIATE_TRY1:
SELECT Z_ID_AFFL, FIELDNAME, Z_ATTR_VALUE, Z_DTTM_STAMP,rownum from $(vUS_Sch).PS_Z_RW_AFFL_ATTR where Z_ID_AFFL='1771';
STORE PS_Z_RW_AFFILIATE_TRY1 into [$(vUS_QvdPath)REGW_AFF_ATTR_TRY.qvd](qvd);
Drop table PS_Z_RW_AFFILIATE_TRY1;

PS_PS_Z_RW_AFFL_ATTR_TRY:
Load Z_ID_AFFL, FIELDNAME, text(Z_ATTR_VALUE), Z_DTTM_STAMP from [$(vUS_QvdPath)REGW_AFF_ATTR_TRY.qvd](qvd);

Below is the data in the oracle database

This is the output that i am getting

[Anil_Babu_Samineni]

Perhaps this and see if that makes OK?

If(Len(Z_ATTR_VALUE)=1, Z_ATTR_VALUE, Text(Z_ATTR_VALUE)) as Z_ATTR_VALUE