Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ALL,
Can Anybody please help to solve this puzzle....
Thanks..
yes but for every day qvd file should be new, with date stamp...and previous qvd should not be deleted...
so that day after tommorw i have 2 avd file or say 2 previous day data
Help me guys
Hi,
You mean to say daily you want to create a qvd file for that day only.
Then you can do like this.
Load Filed1, Filed2
From xyz where date = date(today(),'DD/MM/YYYY')
For previous day use like this.
Load Filed1, Filed2
From xyz where date = date(today()-1,'DD/MM/YYYY')
Regards,
Kaushik Solanki
yes but for every day qvd file should be new, with date stamp...and previous qvd should not be deleted...
so that day after tommorw i have 2 avd file or say 2 previous day data
T1:
Load F1,
F2,
F3,
Date
;
Select F1,
F2,
F3
From abc
where Date=<today's date> /* make sure the date format is same as from Database*/
;
Let qvd_date=Peek('Date',0,T1) /* to create a variable so that you can differentiate between the qvds*/
Store * from T1 into $(qvd_date).qvd;
Hope this will help you.