Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
siddharth_kulka
Creator II
Creator II

Multiple binary loads in 1 qvw

Scenario:

We have 3 major applications(around 500 MB each) and the user wants to merge all 3 at the backend(around 1.5 G). No UI is required. This is just for easy of testing, instead of opening 3 separate apps for production support whenever an issue arrives

-->Qlikview just allows one binary load in d script.

-->Any tricks on merging all 3, using binary loads?

-->I don't want to merge their scripts and load, as it wud take use a lot of time.

Any thoughts/inputs?

Thanks,

Siddharth

14 Replies
IAMDV
Luminary Alumni
Luminary Alumni

Good decision Siddharth.

This will be one of excerise but you can always use these QVD's in future. QVD are much faster than the normal Load process. And if you are extracting this data from database then you are keeping your DBAs happy for not uses the DB resources everytime you load the data.

Good luck!

Cheers - DV

Not applicable

Hi there ,

I'm quite new to QV. Can anyone help me to find out a way to import and  merge 3 QW application into one.

I have them stored on 😧 drive.

D:\MMix 1980-2011

Global Model Mix 1980-2011 (2010-2011).qvw

Global Model Mix 1980-2011 (2000-2009).qvw

Global Model Mix 1980-2011 (1980-1999).qvw

BINARY myqvw.qvw;

FOR i = 0 to NoOfTables()-1

LET vTableName = TableName($(i));

LET vOutfile = '$(vTableName).qvd';

STORE [$(vTableName)] INTO [$(vOutfile)] (qvd);

NEXT i

shivani_singhal
Partner - Contributor III
Partner - Contributor III

Hi,

 

Can you explain me that myqvw.qvw  is which file. My first file or any other. 

I used this code 

BINARY lib://HUB (hgil_qlik.sense)/8efee386-a3af-4110-90b5-e467de7a9686;

FOR i = 0 to NoOfTables()-1

LET vTableName = TableName($(i));

LET vOutfile = '$(vTableName).qvd';

STORE [$(vTableName)] INTO [$(vOutfile)] (qvd);

NEXT i

Here, I took the binar of first file. And getting this error,

Started loading data
 
{0}
 
The following error occurred:
No qualified path for file: ***
 
The error occurred here:
STORE [B1] INTO [B1.qvd] (qvd)
 
Data has not been loaded. Please correct the error and try loading again.
 
Thanks in advance.
Regards,
Shivani Singhal
hectorgarcia
Partner - Creator III
Partner - Creator III

I would sugest to use the solution posted by @rwunderlich  on his cookbook https://qlikviewcookbook.com Table Spinner...   with this you create your qvw's datamodel into qvd's and then you use this qvd's .

 

what you save here is all the process the origin qvw's do for yow.

 

Is not conventional but it works ...

 

Amit_Kakkad_PD
Contributor II
Contributor II

Ingenious solution! Thanks!