Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
bvmike2001
Contributor III
Contributor III

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

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!

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

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

View solution in original post

5 Replies
marcus_sommer

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

bvmike2001
Contributor III
Contributor III
Author

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?

ashfaq_haseeb
Champion III
Champion III

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

bvmike2001
Contributor III
Contributor III
Author

Many thanks, ASHFAQ!

I will study your EDX trigger solution.

ashfaq_haseeb
Champion III
Champion III

If it answer,

Close the thread after all your study.

Regards

ASHFAQ