Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

anuradhaa
Not applicable

Create QVD file using CSV file

Hi,

Please help me to create QVD file using CSV file.

Thanks,

Anuradha

1 Solution

Accepted Solutions
mayilvahanan
Not applicable

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
Not applicable

Re: Create QVD file using CSV file

hi,

I hope the attach application helps you out.

Deepak

mayilvahanan
Not applicable

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
Not applicable

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
Not applicable

Re: Create QVD file using CSV file

Thanks All