Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

anuradhaa
Contributor

Create QVD file using CSV file

Hi,

Please help me to create QVD file using CSV file.

Thanks,

Anuradha

1 Solution

Accepted Solutions
Highlighted

Re: Create QVD file using CSV file

Hi,

    

Testing:
LOAD TaxID,
     Company
FROM
[clients.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Store Testing into Test.qvd;

Hope it helps

4 Replies
deepakk
Valued Contributor III

Re: Create QVD file using CSV file

hi,

I hope the attach application helps you out.

Deepak

Highlighted

Re: Create QVD file using CSV file

Hi,

    

Testing:
LOAD TaxID,
     Company
FROM
[clients.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Store Testing into Test.qvd;

Hope it helps

ngulliver
Valued Contributor III

Re: Create QVD file using CSV file

Hi,

If you don't feel confident about coding the load then use the File Wizard.

     - In the Edit Script, click on the Table Files button at the bottom. This will let you choose your .csv file.

     All you need to do is make sure the delimiter is correct according to the content of your csv and select embedded labels on the next page if you have titles in you csv.

Lastly, as Mayil mentions, make sure you have a 'Load Name': above the generated load script and Store 'Load Name' into 'Filename'.qvd after the load script.

anuradhaa
Contributor

Re: Create QVD file using CSV file

Thanks All

Community Browser