Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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,
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 ...
Ingenious solution! Thanks!