topic Re: How do i store multiple data from different qvd in to one in QlikView

How do i store multiple data from different qvd in to one

Sat, 14 Feb 2015 11:24:01 GMT

Hello,

I loaded 5 qvd to a qvw how do i store all to form one qvd

i.e:

[First]:

load

from..... QVD

[Second]:

load

from..... QVD

[Third]:

load

from..... QVD

Store all into a qvd

Re: How do i store multiple data from different qvd in to one

sunny_talwar — Sat, 14 Feb 2015 11:32:20 GMT

UPDATE:
you will either have to concatenate or join them into one table and then store it into a qvd. As per my understanding you can only store one table per qvd.

First:

load

from..... QVD

Concatenate (First)

load

from..... QVD

Concatenate (First)

load

from..... QVD

Store First into location.qvd (qvd)

HTH

Best,

Re: How do i store multiple data from different qvd in to one

Sat, 14 Feb 2015 11:47:20 GMT

I dont wanna concatenate, doing this wont give u flexible association

Re: How do i store multiple data from different qvd in to one

sunny_talwar — Sat, 14 Feb 2015 12:53:08 GMT

If you want to save the data structure as it is and don't want to combine them into one, then I think you can save them as a qvw file as do a Binary load.

Best,

Re: How do i store multiple data from different qvd in to one

maxgro — Sat, 14 Feb 2015 14:07:29 GMT

can I ask the reason to store 5 tables (qvd) in one qvd?

Re: How do i store multiple data from different qvd in to one

Sat, 14 Feb 2015 15:32:01 GMT

Yes I wanna make use of 1 QVD

Re: How do i store multiple data from different qvd in to one

Anonymous — Sat, 14 Feb 2015 18:24:10 GMT

"I wanna" is the weakest possible reason I know of

Keeping separate QVDs gives the most flexibility, as you've noticed above already.

Re: How do i store multiple data from different qvd in to one

maxgro — Sat, 14 Feb 2015 18:29:06 GMT

Concatenate as already suggested; add a field to remember the source qvd.

But, IMHO, this isn't the correct way to use the qvd; 1 qvd is for 1 table.

If you have 5 already associated tables, store in 5 .qvd; when you need those tables, read the 5 qvd in a different qvw document and you'll get the same in memory db; you can also only read some of the qvd. I think this is more flexible than 5 tables in 1 qvd.

if you want to store all your model (database = many tables) in one file for later reuse, use a .qvw and a binary load to read it .

Re: How do i store multiple data from different qvd in to one

Anonymous — Sat, 14 Feb 2015 18:30:10 GMT

Although, if you want a worse solution, I can give you a bad advice:

First:

load

1 as TableNum,

...

from..... QVD;

Concatenate (First)

load

2 as TableNum

...

from..... QVD;

Concatenate (First)

load

3 as TableNum

from..... QVD;

............

Store First into Full.qvd (qvd);

When you read from QVD, and want only Second table:

LOAD

... // all fields except TableNum here

FROM ...

WHERE TableNum=2;

Re: How do i store multiple data from different qvd in to one

Sun, 15 Feb 2015 12:39:21 GMT

Hello All,

I pulled my data from SAP BW using QvSAPOLAPConnector storing to QVD and pushing my data direct to MS SQL so i can manipulate my data there. Am not saying i want to make use of one QVD because i just wanna make use of it plz...

Re: How do i store multiple data from different qvd in to one

Anonymous — Sun, 15 Feb 2015 16:12:40 GMT

Hi Emac,

As Maximo suggested a qvd is for one table and if you want to store all tables in one qvd,you need

to use Concatenate(merge rows) for same structure tables and join(merge columns) for different structure tables.

and store in single qvd.

another option as suggested is to build a datamodel with 5 tables in one qlikview document and use it as binary load in another qlikview document.

in both above options you can use flags(binary status indicators) to differentiate source table.

if above solutions doesn't solve your purpose.

please give specific details what is your requirement.so community members can try to help

And by manipulating data do you mean Transformations.

In qlikview you can make any transformations and you don't need to push data to MS SQL for any transformations.

Regards

Neetha