Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
lyj1990
Contributor
Contributor

Conditional Load in Script

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 

Labels (2)
1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

Try it with:

[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] where not exists(StatusDate, date(today(),'DD/MM/YYYY'));

STORE PastStatus INTO $(vExclPath)\DailyStatus (qvd);

drop Table [PastStatus];


- Marcus