Issue in QVD generation values

[#1]

Hi,

I have values like

fruitcode

1

01

0334

334

But When Iam storing into a qvd file.It is storing like

fruitcode

1

1

334

334

But I dnt want like this.I want the exact data itself..Can anyone help me out?

[disqr_rm]

you can load it as:

LOAD text(fruitcode) as fruitcode .......

Then it will load it as text and you will see the exact data.

If data is numeric, QlikView automatically converts it to number to store internally --> Memory optimized.