topic Re: Create QVD file using CSV file in QlikView

Create QVD file using CSV file

anuradhaa — Wed, 27 Jun 2012 11:39:17 GMT

Hi,

Please help me to create QVD file using CSV file.

Thanks,

Anuradha

Re: Create QVD file using CSV file

deepakk — Wed, 27 Jun 2012 12:02:21 GMT

hi,

I hope the attach application helps you out.

Deepak

Re: Create QVD file using CSV file

MayilVahanan — Wed, 27 Jun 2012 14:04:55 GMT

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

Re: Create QVD file using CSV file

ngulliver — Thu, 28 Jun 2012 10:38:53 GMT

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.

Re: Create QVD file using CSV file

anuradhaa — Fri, 29 Jun 2012 07:55:17 GMT

Thanks All