Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

renjithpl
Valued Contributor

Task Dependancy

Hi All,

Can QMC triggers a task based on the availability of a folder or a .mdb file.?

How can i achieve this ?

Regards

Ren

4 Replies
dmohanty
Valued Contributor

Re: Task Dependancy

Dependencies can be created in QMC using triggers..no doubt. You can have multiple files dependent on each other for reload.

You have to select "On event from another task" for the subsequent files. For the first file, you have to select "on a schedule"

Screenshot below:

Test.png

Not applicable

Re: Task Dependancy

I thing we cant do this.

we can do this in script with If statement.

if(fileexists(filepath))

statement;

end if

Reagrds,

Kabilan K.

Re: Task Dependancy

The best way to do this, I guess, is to monitor files and folders outside of QlikView.

A small program or batch (CMD) file checks the availability of this file or folder. Upon detecting the right stuff, it sends an EDX request (there is a command line tool for that, see QMSEDX_commandline in doc http://community.qlik.com/docs/DOC-2650) to your reload task. Configure your reload task to also trigger on receiving an EDX request.

Now schedule your monitoring tool using Windows Task Scheduler to go and check with the preferred frequency and you're on your way.

Luck,

Peter

Not applicable

Re: Task Dependancy

Hi,

you can do but with the help of external task.

1. Use the EDX task trigger for the same and write script accordingly. else you can follow the below steps(both) for your requirement but it not exactly what you want.

2. Create a batch file which execute the reload when the required file exist :- Algoritham

if file exist

     reload qvw

     else

print Not present

3. Create a external task using above file and sechedule it every 5 min.

Thanks,

D J