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

[Anonymous]

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,

[#2]

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;

[#3]

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]

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]

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