check the existence of a qvd file

[ali_hijazi]

Hello

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

thank you

[pat_agen]

hi,

bookmarked this earlier today - think it does what you are after.

http://community.qlik.com/thread/28381

[#3]

Hi there,

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

else

//file exists

end if

Hope this helps,

Liam

[#4]

Hi Ali,

So you want to do similiar in your Edit Script.

if isnull(filetime('d:\datadump.qvd')) then

datadump:
ODBC CONNECT TO  DataRepository;

sql
SELECT
NAME,
MONTH, 
STATUS

FROM     dbo.Data;

store datadump into datadump.qvd;

else

load * from datadump.qvd (qvd);

end if;

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.

-Liam