topic Re: generating QVD from xls in QlikView

generating QVD from xls

marksmunich — Tue, 07 May 2013 08:20:33 GMT

Hello,

How to create a QVD file from .xls file.

what script must be used to perform this task.

Mark

Gysbert_Wassenaar — Tue, 07 May 2013 08:29:34 GMT

Just a load and a store command:

Table1

Load * from ...myexcelfile...;

Store Table1 into myqvdfile;

Sokkorn — Tue, 07 May 2013 08:34:45 GMT

Hi,

Suppose that your qvw and excel in the same directory.

[ExcelData]:

Load * from MyExcel.xlsx;

Store [ExcelData] Into MyQVD.qvd;

Regards,

Sokkorn

Tue, 07 May 2013 08:47:02 GMT

table1:

load

id,

name,

address

from table1;

store table1 into D:\ table1.qvd;