topic qvd in QlikView

qvd

Fri, 08 Feb 2013 08:28:10 GMT

HI all,

can we create a qvd with fields of multiple tables?

Re: qvd

Anonymous — Fri, 08 Feb 2013 08:48:27 GMT

No. See reference to Store command, page 267 of Reference Manual (v11 SR1):

Store

A QVD or a CSV file can be created by a store statement in the script. The statement will create an explicitly named QVD or CSV file. The statement can only export fields from one logical table. The text values are exported to the CSV file in UTF-8 format. A delimiter can be specified, see Load (page 246). The store

statement to a CSV file does not support BIFF export.

Jonathan

Re: qvd

Anonymous — Fri, 08 Feb 2013 09:02:54 GMT

But you can of course create a table in the script with data from multiple tables and then export this table as one QVD file.

Re: qvd

hic — Fri, 08 Feb 2013 09:04:35 GMT

Jonathan is right about the Store statement.

However, it is also possible to create a QVD by exporting a straight table from the GUI and choosing "QVD" as export format. And here you can have fields from multiple tables.

HIC

Re: qvd

er_mohit — Fri, 08 Feb 2013 09:06:27 GMT

if you already did join.

and you have only one tablein your data model.

now store that table which are not joined for making a qvd

T1:

load *

from table1;

join

load * from table 2;

join

load *

from table3;

STORE T1 INTO tableQ1.qvd (qvd);

then you can make one qvd of multiple tables .

hope it helps