QlikView documentation and resources.
The below script helps in creating the qvds for each table in the datamodel of a Qlikview file.
FOR vCount = 0 to NoOfTables()-1
LET vTableName = TableName($(vCount));
STORE $(vTableName) INTO $(vTableName).qvd (qvd);
Refer this thread for more details
Reload QlikView Application (QVW) File Without Access To Data Source(s)
Just what I needed! Spitze!
Thanks for the script. I am wondering how to use it. Could you please provide a sample app.
If you have a qlikview file and you want to save all the tables into QVDs then try like this
Create a new file and binary load the QVW which you want to create QVDs and use below script
Hope this helps you.
Excellent code, Jagan. This is very helpful
Jagan, is it possible to add additional code to the above code block to restrict the number rows in each QVD to just 100 rows?
Try something like this
First 100 LOAD
STORE Temp INTO $(vTableName).qvd (qvd);
DROP TABLE Temp;
Too good code Jagan.....
I have a similar reqts but I am reading data from spreadsheets and I have listed the names in an inline table below.
SET DATA_FilePath='C:\Users\43862460\Desktop\Incremental Load\';
ILES:load * Inline [ FileName Echannels MEHIE ];for i = 1 to FieldValueCount('FileName')let lastexectime = num(date(ReloadTime(),'MM/DD/YYYY hh:mm:ss TT'));let BeginningThisExectime = num(date(now(),'MM/DD/YYYY hh:mm:ss TT'));let vFileName = FieldValue('FileName',$(i));$(vFileName):load*FROM [$(DATA_FilePath)$(vFileName).xlsx] (ooxml, embedded labels) where ([Modified Date] >= '$(lastexectime)' and [Modified Date] < '$(BeginningThisExectime)' ) ;
STORE $(vFileName) into [$(DATA_FilePath)$(vFileName).qvd](qvd);next i;drop Table FILES;
This script run fine when there is a single File name and generates qvd.
The moment I add a second file name to it it says unable to store the second qvd in the given path. The first qvd gets created successfully but I am getting an error while creating the second qvd.
Will you be able to suggest what is going wrong?
when I used noconcatenate before the load statement it worked fine..I am still not able to understand why it worked with noconcatenate
Why this storing only the last table value? Is it because QVD file only store single table value?
STORE $(vTableName) INTO 'lib://Assignment01/ALL.qvd' (qvd);
// STORE $(vTableName) INTO 'lib://Assignment01/$(vTableName).qvd' (qvd);