Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ali_hijazi
Honored Contributor

store multiple tables in one qvd document

Hello

can we store multiple tables in one qvd document?

if yes how can we load data from this document?

2 Replies
Not applicable

store multiple tables in one qvd document

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

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

Not applicable

store multiple tables in one qvd document

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;