Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
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

12 Replies
IAMDV
Luminary
Luminary

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
Partner

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