Create QVD file using CSV file

[anuradhaa]

Hi,

Please help me to create QVD file using CSV file.

Thanks,

Anuradha

[deepakk]

hi,

I hope the attach application helps you out.

Deepak

[MayilVahanan · Accepted solution]

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]

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]

Thanks All