Re-creating qvd file at certain time

[ttal7878]

Hi community,

Is it possible for qvd file to be recreated at certain times?

For example, every day at 4 am, the Qvd file will be recreated.

In my model I'm using incremental load,if the qvd file doesn't exist,the file is re-created.

                                                               If the qvd  file exists there is only loading of the delta.

I would like to add an additional condition in addition to checking whether the file exists.

The condition is:

If the time is 4 am - the qvd file  will re-create,no matter if the Qvd file exists or not

I have included an example model

[avinashelite]

you could check of the QVD created time using the function

QvdCreateTime('C:\MyDir\MyFile.qvd')

based on the time you could base you load condition , hope this helps you

[kaushiknsolanki · Accepted solution]

Try this,

Let vTime = if(time(now() - today()) >= MakeTime(04,00,00) and num(time(now() - today())) <= MakeTime(04,05,00),1,0);

IF $(Is_QVD_File_Exists) = -1 or $(vTime) = 1 THEN

I have kept a window of 5 minutes, you can change as you want.

Regards,

kaushik Solanki

[ttal7878]

Thank you!