How to load data from 2 QVW into single QVW file.

[deepakqlikview_123]

How to load data from 2 QVW into single QVW file.

Thanks

[Aurelien_Martinez]

Hi,

You can try this solution :

Multiple binary loads in 1 qvw

Aurélien

[ali_hijazi]

using Binary loads QlikView allows only from one QVW file

you can loop through all tables of the 2 documents and save them as QVD as follows:

for i=NoOfTables() to 0 step -1

  let vTableName = TableName($(i));

  if not isnull(NoOfRows('$(vTableName)')) then

       store $(vTableName) into 'your_path' &  $(vTableName).qvd (qvd);

  endif

  next

then in your final document you simply read the QVDs where you stored them above

[maleksafa]

normally you can use binary load to load one qvw into another qvw, in your case it can be a little tricky if you are taking from two different qvws as it might ruin your schema (linking on the names etc...) so it is better to generate all the tables of your qvw into qvds and then read the qvds that you want in your destination qvw.

[its_anandrjs]

Hi Deepak,

Sorry at a time you can load only on binary file, If there is requirement like load 2 QVW into single then try loading one by one qvw.

1. Binary Qvw create by one  QVW

Ex:-

Binary Qvw  >> 1.QVW

2. Then use this second QVW

Binary QVW + 1.QVW >> 2.QVW

3. Then you get final 1.QVW + 2.QVW in single binary file

Its better if you create the QVDs of this binary files and then use it in the model because in the binary may be the synthetic keys created and the tables also.

Regards

Anand

[ali_hijazi]

only one Binary load statement is allowed in a document

[#7]

Hi,

If you have 1.QVW and 2.QVW then you want load all the data into 1 application right.

just goto 1.QVW then use binary statement of the 2.QVW file into 1.QVW

so here 1.QVW file contains like dis

binary 2.QVW;

all the tables whatever already u have it in ur application(1.QVW)