Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please help me to create QVD file using CSV file.
Thanks,
Anuradha
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
hi,
I hope the attach application helps you out.
Deepak
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
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.
Thanks All