This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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 //*Daily Reload 1 time only*//Status,
date(today(),'DD/MM/YYYY') as StatusDateResident [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
Try it with:
[PastStatus]: //*Daily Reload 1 time only*//
date(today(),'DD/MM/YYYY') as StatusDate
Resident [DailyStatus] where not exists(StatusDate, date(today(),'DD/MM/YYYY'));