Conditional Load in Script

lyj1990 — Fri, 15 Nov 2024 23:34:39 GMT

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

Re: Conditional Load in Script

marcus_sommer — Tue, 24 Nov 2020 09:03:35 GMT

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

topic Conditional Load in Script in QlikView

Conditional Load in Script

Re: Conditional Load in Script