Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

sumitjadhav
Contributor II

HOW TO LOAD TWO DATA MODELS OR TWO QVW FILES IN TO THE OTHER QVW FILE?

HOW TO LOAD TWO DATA MODELS OR TWO QVW FILES IN TO THE OTHER QVW FILE?

6 Replies

Re: HOW TO LOAD TWO DATA MODELS OR TWO QVW FILES IN TO THE OTHER QVW FILE?

Hi sumit,

Check the below link..

Multiple binary loads in 1 qvw

Re: HOW TO LOAD TWO DATA MODELS OR TWO QVW FILES IN TO THE OTHER QVW FILE?

Hi Sumit,

we don't have a direct option to load multiple qvw's into a single QVW, either you need to create QVD for each or you need to load 1st qvw into second and then again load the 2nd qvw into the 3rd document . This way we can load the 2 qvw s into 1 .

Hope this helps you

santhosh_k_n
Contributor

Re: HOW TO LOAD TWO DATA MODELS OR TWO QVW FILES IN TO THE OTHER QVW FILE?

Hi,

If only datamodel is required, try exporting the script of the two QVW files and import them in the new one.

BR

SK

MVP
MVP

Re: HOW TO LOAD TWO DATA MODELS OR TWO QVW FILES IN TO THE OTHER QVW FILE?

For one .qvw (or data model) you can use a binary load.

Qlikview only allows one binary load, so for more than 1 .qvw or data model you have to use a different way:

1) Save the data model of your source .qvw (A.qvw, B.qvw) using qvd (1 file = 1 table) with the store script command

2) In your target .qvw (T.qvw):

- load the qvd you made from A.qvw; load the .qvd you made from B.qvw

- or  binary load the A.qvw and then load the .qvd you made from B.qvw

- or binary load the B.qvw and ...............

Re: HOW TO LOAD TWO DATA MODELS OR TWO QVW FILES IN TO THE OTHER QVW FILE?

If your Purpose is Reporting.

Then you can use Nprinting.

Provided Both model have some common key to connect.

Regards

ASHFAQ

MVP
MVP

Re: HOW TO LOAD TWO DATA MODELS OR TWO QVW FILES IN TO THE OTHER QVW FILE?

Hi Sumit,

It is not possible to do two binary loads in Qlikview, the only thing you can do is

1. Binary load the first file

2. copy the script in second file and reload

This way we can load two data models into one qlikview file.

Hope this helps you.

Regards,

Jagan.

Community Browser