how to convert text file into qvd?

[#1]

Hi, how do I convert a text file to a qvd file without downloading converter software? Thanks.

[jagan]

Hi,

Load the data into Qlikview from Text file and convert to QVD using STORE command. Try below script

Data:

LOAD

*

FROM TextFile.txt;

STORE Data in Data.qvd;

DROP TABLE Data;

Hope this helps you.

Regards,

Jagan.

[engishfaque]

Dear Rachel Boey,

Here is the quick solution with example.

Step 1:

---------

File > Edit Script > Data > Table Files > Select txt file > Finish.

Example:

---

CustomerSale:

LOAD Year,

     Sale

FROM

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Step 2:

---------

STORE CustomerSale into E:\QlikView\qvd\CustomeSaleFile.qvd;

Kind regards,