Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

how to convert text file into qvd?

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

2 Replies
MVP & Luminary
MVP & Luminary

Re: how to convert text file into qvd?

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
Valued Contributor III

Re: how to convert text file into qvd?

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,