Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, how can I convert excel files and database tables to qvd format without downloading software? Thanks.
Dear Rachel Boey,
Here is the two steps and easiest solution.
Same way you can convert excel files and database tables to qvd format without downloading any software.
Step 1:
---------
File > Edit Script > Data > Table Files > Select txt file > Finish.
Example:
---
CustomerSale:
LOAD Year,
Sale
FROM
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);
Step 2:
---------
STORE CustomerSale into E:\QlikView\qvd\CustomeSaleFile.qvd;
Kind regards,
Ishfaque Ahmed