topic Force reload task to fail in QlikView

Force reload task to fail

Fri, 10 Dec 2010 06:45:13 GMT

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)

Force reload task to fail

Mon, 13 Dec 2010 09:13:00 GMT

IF $(condition ) THEN

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

END IF

Force reload task to fail

Tue, 21 Dec 2010 03:25:56 GMT

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! 🙂

Force reload task to fail

Anonymous — Wed, 02 Mar 2011 11:29:11 GMT

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));

NOT(TABLE_HAS_RECORDS) THEN

//Reload will be cancelled

LOAD

END