Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi . I have an old qvw file which imported data from databases that have been removed now. Now I have to make updates on the qvw file but the reload will not work now since the database is gone. I was wondering if there's a way of storing data from the existing qvw into a qvd file so that I can reload it from there again after making changes to the qvw file.
Cheers,
Varun
Hi,
Try like this
Create a new Qlikview file and do Binary load the old file and put below script to generate the QVDs for the existing tables in the datamodel
BINARY FileName.qvw;
FOR vCount = 0 to NoOfTables()-1
LET vTableName = TableName($(vCount));
STORE $(vTableName) INTO $(vTableName).qvd (qvd);
NEXT vCount
The above script will create the qvds for each table in the datamodel.
You can also check this link below
Storing all tables in Qlikview file to QVD
Hope this helps you.
Regards,
Jagan.
you can create table box in front end for each and every table and export to excel . here you go, You will have the data you want ..
Thanks Praveena. That is possible to do but there are a lot of tables with multiple columns in each so it would be a time consuming process to add all the columns as expressions. Thanks for the suggestion though.
Hi,
Try like this
Create a new Qlikview file and do Binary load the old file and put below script to generate the QVDs for the existing tables in the datamodel
BINARY FileName.qvw;
FOR vCount = 0 to NoOfTables()-1
LET vTableName = TableName($(vCount));
STORE $(vTableName) INTO $(vTableName).qvd (qvd);
NEXT vCount
The above script will create the qvds for each table in the datamodel.
You can also check this link below
Storing all tables in Qlikview file to QVD
Hope this helps you.
Regards,
Jagan.
Hi,
The same issue i am also facing i am trying to load by using binary but the QVW which i have is disabled for the binary load is there any solution for extracting data from it.
Regards
Sagar
Jagan,
Thanks man. Learned new stuff today.
It really works.
Best Regards,
Susvith
Hi,
Open the old QVW document and follow this to remove Binary Load option
Document Properties -> Opening -> Uncheck Prohibit Binary Load option
Hope this helps you.
Regards,
Jagan.
Thank you...
Hi,
This is what I use.
Bill