Hi all,
I have the follow script to load and concantenate the data on a daily basis. This is to help me to build my data trend into a QVD files.
//For Generation Daily Status//
[PastStatus]: //*Daily Reload 1 time only*//
LOAD *
FROM
$(vExclPath)\DailyTrend (qvd);
Concatenate
Load //*Daily Reload 1 time only*//
Status,
Sales,
date(today(),'DD/MM/YYYY') as StatusDate
Resident [DailyStatus];
STORE PastStatus INTO $(vExclPath)\DailyStatus (qvd);
drop Table [PastStatus];
However, at some period our data server would be down and require us to do a manaul reload of the application.
What i need to do is to prevent the data from concanateing again during this manual reload. I tried searching a solution around this forums but i did not come to any solution
