Multiple binary loads in 1 qvw

[siddharth_kulka]

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

[IAMDV]

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

[#3]

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]

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]

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]

Ingenious solution! Thanks!