topic Multiple binary loads in 1 qvw in QlikView

Multiple binary loads in 1 qvw

siddharth_kulka — Tue, 06 Dec 2011 17:06:16 GMT

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

Multiple binary loads in 1 qvw

IAMDV — Tue, 06 Dec 2011 17:22:33 GMT

Siddharth - Have you considered loading from QVDs? As we can use only one binary load in the QV document. You can use Include function to extract script and you can load from QVDs.

I hope others might have better solution.

Cheers - DV

Multiple binary loads in 1 qvw

siddharth_kulka — Tue, 06 Dec 2011 18:02:14 GMT

But that would mean...

Storing all tables from all 3 apps as QVD's..

And then loading those QVD's (optimized)

Storing would take a lot of time.

Multiple binary loads in 1 qvw

Wed, 07 Dec 2011 06:10:39 GMT

Hi Sid,

There is only one trick for it . Do the Binary all the Applicaiton one by one.

Suppose you have 3 applicaiton name as A,B,C

Now,in A take the binary of B and name that applicaiton as A1

After that in Applicaiton C take the binary of A1.

And then you will all the three applicaiton in the One application.

Regards,

Nitin Jain

Multiple binary loads in 1 qvw

Wed, 07 Dec 2011 07:09:58 GMT

as told by nitin you can do as:

take binary load of one qvw in another file and name it as A.

Now take binary load of A.

Multiple binary loads in 1 qvw

rwunderlich — Wed, 07 Dec 2011 08:00:44 GMT

Nitlin,

I don't understand your proposal. If A binary loads B, it will only have the contents of B. Unless you repeat A's script, which the poster was trying to avoid.

-Rob

Multiple binary loads in 1 qvw

rwunderlich — Wed, 07 Dec 2011 08:03:49 GMT

Siddharth,

I don't know of any way around the problem except storing as QVDs. Iit shouldn't take very long to do the store. You can do it with a script loop like this:

BINARY myqvw.qvw;

FOR i = 0 to NoOfTables()-1

LET vTableName = TableName($(i));

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

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

NEXT i

Multiple binary loads in 1 qvw

Wed, 07 Dec 2011 08:04:40 GMT

Hi Rob,

In the Application A take the binary of the Application B. In this coding part of Applicaiton A will also be available to it.Now name it as A1

Hence the Applicaiton A1 contains the :- A(Coding Part) + B (Binary Part).

Regards,

Nitin Jain

Multiple binary loads in 1 qvw

IAMDV — Wed, 07 Dec 2011 08:17:19 GMT

I agree with Rob. QVD is the way to go. I think QVD also helps for future requirements and it is worth the time to create logical grouping of data.

Multiple binary loads in 1 qvw

siddharth_kulka — Wed, 07 Dec 2011 14:31:56 GMT

Thanks every1 for your inputs.

Rob, I agree. Storing QVD's in a loop is the best workaround. Thankyou!

Multiple binary loads in 1 qvw

IAMDV — Wed, 07 Dec 2011 14:49:25 GMT

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

Multiple binary loads in 1 qvw

Thu, 15 Dec 2011 16:59:52 GMT

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

Re: Multiple binary loads in 1 qvw

shivani_singhal — Mon, 22 Apr 2019 08:28:58 GMT

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

Re: Multiple binary loads in 1 qvw

hectorgarcia — Fri, 21 Oct 2022 16:35:57 GMT

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 ...

Re: Multiple binary loads in 1 qvw

Amit_Kakkad_PD — Mon, 02 Sep 2024 08:59:34 GMT

Ingenious solution! Thanks!