Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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