Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
fkeuroglian
Partner - Master
Partner - Master

QMC Reload Process

Hi people i would like to know if there is a posibility to create a Defensive programing in the reload procedure.

for example, i have 3 etl, and they are in secuence: ETL1 then ETL2 then ETL3

now i have checked the option "on event from another task succesfull" and then execute the etl

but if etl1 fail, stop all the process and etl2 and etl3 do not complety and reload ok.

is there a way to create some flag or something to have the posibility to:

RUN ETL1;

IF ETL1 OK THEN

     RUN ETL2

ELSE

     RUN ETL2

IF ETL2 OK THEN

     RUN ETL3

ELSE

     RUN ETL3

Thank you a lot people all the help will be appreciated !

Fernando

6 Replies
Chris_Rice
Support
Support

You should be able to just create two tasks for ETL2 and 3.  So:

IF ETL1 OK THEN

     RUN ETL2 Task 1

ELSE

     RUN ETL2 Task 2

IF ETL2 OK THEN

     RUN ETL3 Task 1

ELSE

     RUN ETL3 Task 2

Both Task 1 and Task 2 are the same thing, just triggered differently.

rwunderlich

If I understand, you want to run ETL2 when ETL1 completes, either successful or failure? Do you have Publisher? If so, you can define both triggers.

-Rob

fkeuroglian
Partner - Master
Partner - Master
Author

Hi, Rob

I do not have publisher, there is another posibility without publisher?

thank you rob

Chris_Rice
Support
Support

I don't think that's possible with QlikView sans Publisher, but you should be able to set up external tasks and triggers.

http://community.qlik.com/docs/DOC-3024

Not applicable

Just create 2 triggers; one for success and another for failure

fkeuroglian
Partner - Master
Partner - Master
Author

Kiru, explain more

what would you use and put an example , where and how do you create the two triggers?