topic Re: Qlikview , removing leading zero when loading CHAR from database to QVD. in QlikView

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

kattis68 — Mon, 20 Dec 2021 07:52:12 GMT

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.

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

anat — Mon, 20 Dec 2021 08:19:57 GMT

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

load col1,text(col2);

select col1,col2 from table;

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

anat — Mon, 20 Dec 2021 08:20:33 GMT

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

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

kattis68 — Mon, 20 Dec 2021 14:05:05 GMT

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