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

[sivaboggarapu20]

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

[ChennaiahNallani]

create EDX file.

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Server/Content/QlikView-Server/QVSRM_Pu...

[sivaboggarapu20]

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

[agigliotti]

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.

[MK9885]

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.