Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Thank you!