topic QV 11 / Start a reload task only if/ after source table is updated in QlikView

QV 11 / Start a reload task only if/ after source table is updated

bvmike2001 — Wed, 21 Jan 2015 12:20:00 GMT

Hello,

please help me to understand what to do and how to configure task in QMC in order to start a reload task for a QVD only if/ after the source table was updated with new record.

Consider that i can use a log table from witch i can read the timestamp of the last success table update.

Do i need to build a designated qvw file in order to capture that event and after...?

Thanks!

Re: QV 11 / Start a reload task only if/ after source table is updated

marcus_sommer — Wed, 21 Jan 2015 20:16:53 GMT

Within the qmc by the reload-trigger options from the app you could start a reload in dependence from another successful reload-task. But this meant not necessary that a particular qvd has new records. If this is needed you could write a small if-statement in the beginning from a load-statement to check this:

if filesize(qvd) > $(vFilesize) then // there are many more functions like this available

let vFilesize = filesize(qvd);

else

exit script;

end if

- Marcus

Re: QV 11 / Start a reload task only if/ after source table is updated

bvmike2001 — Thu, 22 Jan 2015 07:49:00 GMT

Hello Marcus,

many thanks for your reply.

My plan is to update the QVD only if the source table is updated and after the QVD update task is finished i will reload the app through task success dependency.

So my question is how to do this?

I have to build a new app that has a continuous reload a test if the source table is updated and base o this to reload the QVD with dependency?

Re: QV 11 / Start a reload task only if/ after source table is updated

ashfaq_haseeb — Thu, 22 Jan 2015 07:56:03 GMT

Hi,

Below discussions will help you.

http://community.qlik.com/message/553748#553748

http://community.qlik.com/message/494538#494538

You need to create and EDX trigger.

Regards

ASHFAQ

Re: QV 11 / Start a reload task only if/ after source table is updated

bvmike2001 — Thu, 22 Jan 2015 08:32:54 GMT

Many thanks, ASHFAQ!

I will study your EDX trigger solution.

Re: QV 11 / Start a reload task only if/ after source table is updated

ashfaq_haseeb — Thu, 22 Jan 2015 08:50:03 GMT

If it answer,

Close the thread after all your study.

Regards

ASHFAQ