Discussion Board for collaboration on QlikView Scripting.
I'm loading data from access database
what I want is save the data into a qvd file
I'm using the "Store" command
what I want is that to check if the qvd file doesn't exist then I store the data in the qvd file otherwise I simply load data from the qvd file already saved
bookmarked this earlier today - think it does what you are after.
In your Script, you can use the filetime() function to check if a file exists.
So, for example, :
if isnull(filetime('c:\data.qvd)) then
//file doesnt exists
Hope this helps,
So you want to do similiar in your Edit Script.
if isnull(filetime('d:\datadump.qvd')) then
datadump:ODBC CONNECT TO DataRepository;
sqlSELECTNAME, MONTH, STATUS
store datadump into datadump.qvd;
load * from datadump.qvd (qvd);
Now of course change your connection setting to what is appropriate to you and of course the filenames and sql select statement. They are just there for an example.
Hope this helps.