Qlikview , removing leading zero when loading CHAR from database to QVD.

[kattis68]

Hello ,

I have a question.  When loading from a oracle  database to a QVD ,one column (VARCHAR2(50 CHAR)) is treated as a integer and the leading zero is removed , 0100975 appears as 100975.

The job works like this. First data is load from database with sql to QVD and then data is load from that QVD to Main QVD. 

Then i have tried to add Text() to QVD but is not working and i have tried added to_char to sql but no difference.

Please suggest.

Thanks in advance.

[anat · Accepted solution]

can u try preceding load before the select statement like..

load col1,text(col2);

select col1,col2 from table;

[anat]

https://community.qlik.com/t5/Knowledge/Leading-zeros-are-missing-in-loaded-data-values/ta-p/1711882

[kattis68]

Hello, it worked!  Thank you very much for your help.