qvd

[#1]

HI all,

  can we create a qvd with fields of multiple tables?

[Anonymous]

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

[Anonymous]

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.

[hic]

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

[er_mohit]

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

like

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