Force reload task to fail

[#1]

Hi all,

Is there any way to force a reload task to fail? I want to stop the execution of the script/reload when no data is returned. I need it to be "failed" so that subsequent task scheduled in Publisher would not execute. (scheduled task will only be executed if previous task completed successfully)

[#2 · Accepted solution]

IF $(condition ) THEN

LOAD * from inexistent.txt (txt, codepage is 1252, no labels, delimiter is '\t', msq) ;

END IF

[#3]

Thanks! I just put some non-correct syntax in code and it can stop (Unknow statement error.) Work same the way the you suggested. Thanks again! 🙂

[Anonymous]

When loading SQL tables with the scheduler into Qlikview it can happen that the process, which fills the SQL Table, has not finished and the table is empty. This leads to a working reload but unfortunately the qlikview application is empty.

In this case (SQL table has 0 records) it would be better not to reload (cancel reload) and keep the previous loaded data.

TPR:

SQL

SELECT count(*) as number_of_records

FROM

SCHEMADB.TPR;

LET

TABLE_HAS_RECORDS = round(peek( 'NUMBER_OF_RECORDS', 0, TPR));

IF

NOT(TABLE_HAS_RECORDS) THEN

//Reload will be cancelled

LOAD

END

IF