topic store multiple tables in one qvd document in QlikView

store multiple tables in one qvd document

ali_hijazi — Wed, 25 May 2011 14:25:45 GMT

Hello

can we store multiple tables in one qvd document?

if yes how can we load data from this document?

Wed, 25 May 2011 14:35:19 GMT

If those tables could be concatenated, the answer is yes.

If not, each table has to be stored in a single qvd file

Thu, 26 May 2011 04:01:34 GMT

If u want to save data from two tables into a single qvd then u need to either concatenate them and then give a single Table name.

If its really necessary for u then try this:

abc:

Load

Col(1),

Col(2),

'table a' as junk

from table a.csv;

Concatenate

Load

Col(3),

Col(4),

'table b' as junk

from table b.csv;

Store abc into abc.qvd;