Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

How to schedule a task in QMC based on SQL Query?

Hi Team,

I have requirement and I have qlik extractor, I need to trigger task only when should start only if stat_cd=2 from DBT_META_CTCT_PRD.TB_PROCESS table.


How Can I given above condition in QMC, please let me know



Thanks,

Siva

4 Replies
Highlighted
ChennaiahNallani
Contributor III

Re: How to schedule a task in QMC based on SQL Query?

Partner
Partner

Re: How to schedule a task in QMC based on SQL Query?

Hi Chennaiah,

Thanks for your reply. But, I want to configure in Qlik Sense (QMC).

Please let me know, how to configure above requriement ?

Thanks,

Siva

Partner
Partner

Re: How to schedule a task in QMC based on SQL Query?

you could use something as below on top of your script:


if stat_cd <> 2 then

     LOAD * FROM dummy.csv (txt);

     EXIT SCRIPT;

end if

in this way you exit from script if the required condition fails.

I hope it helps.

Khan_Mohammed
Honored Contributor II

Re: How to schedule a task in QMC based on SQL Query?

I don't think you can write a condition in QMC.

As Andrea mentioned you can run or stop your extraction based on stat_cd<>2

when your QMC task kicks in it would run the load in app, if the condition is satisfied it would fetch the records or exit the script.

If you transform is dependent on your extract then maybe you'd have to give condition there as well but either way in QMC the task would not fail and all the depended tasks would run but not get new records.