Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
shubham_kumar
Contributor III

Can we save more than one table into the one .qvd file?

I want to save different different table name into the one qvd file. Can anybody will help me to do this?

Example:

A:

Load Col1,col2 from abc.csv;

B:

Load col3,col4 from xyz.csv ;

Can i Store Like this: Store A,B into AB.qvd;???

Best Regards,

4 Replies
Not applicable

Re: Can we save more than one table into the one .qvd file?

I don't think So...

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

If its really necessary for u then try this:

abc:

Load

Col(1),

Col(2),

'a' as junk

from table a.csv;

Concatenate    / / or Left Join

Load

Col(3),

Col(4),

'a' as junk

from table b.csv;

Store abc into abc.qvd;

Not applicable

Can we save more than one table into the one .qvd file?

Shubham Kumar, As far as i know. It is not possible.

One approach would be concatenating both tables in to one table with external field to identify the table while retrieving like

A:

Load Col1,col2,'Table A' as Table from abc.csv;

Concatenate

Load col3,col4,'Table b' as Table from xyz.csv ;

Store A into AB.qvd;

While loading this AB.QVd you can use this Table Flag to segregate the table A & B.(But This is not the advisable Way to store data).

If you can explain us your business logic, then we could think about better solution

yasus
New Contributor III

Re: Can we save more than one table into the one .qvd file?

Hi Shubham,

you can use a concatenated Load to achive this task. I would suggest to add a source-tag for each table/source.

A:

Load Col1,col2, 'abc.csv' as Source from abc.csv;

B:

Concatenate Load col3,col4, 'xyz.csv' as Source from xyz.csv ;

Store A into AB.qvd;

montubhardwaj
Valued Contributor

Re: Can we save more than one table into the one .qvd file?

Not possible until you use Join or Concatenate to make it a single QV table.

Community Browser