Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

johnhhtp2
Contributor II

Need help on Call parameter on QMC

I have 5 tables in my extract.qvw  file, out of this 2 tables are from database1 (DB1)to be scheduled at 8:00 AM and remaining tables are from database1 (DB2) to scheduled at 9:00AM

I came to know that this can be done through QMC by passing parameter name and parameter value in Reload Tab , so here there will be two tasks where one should run at 8 Am and other at 9 AM

pls help

John

6 Replies

Re: Need help on Call parameter on QMC

You'll need a Publisher for that.

See QMC->Source Documents->Select document->Task->Reload->Script Parameters. Enter a variable name in the top input box and a value that controls which QVDs will be stored by your document in the lower one.

Note that the variable must exist before script execution is started. Create the variable in the Variable overview instead of in your script. If you manipulate your variable in your script with LET/SET v=value, then you'll always loose the passed value.

QMC Help contains more information on how to set this up and how to pass multiple values (for example to create multiple end-user documents)

Peter

Gabriel
Valued Contributor II

Re: Need help on Call parameter on QMC

Hi,

What I will do in this case is to split my script into 2 part using variable (i.e. vReloadTime) See below for example. Still pass the variable into QMC  i.e.  QMC->Source Documents->Select document->Task->Reload->Script Parameters.

Set up two task 8:00 AM and 9:00 AM using same qvw file.

Like this.

IF vReloadTime = 0 THEN

     //Reload 8:00 AM script

     tb1:

LOAD

*

FROM DB1;

STORE tb1 INTO \\..........;

ELSE

     //Reload 9:00 AM script

     tb2:

LOAD

*

FROM DB2;

STORE tb2 INTO \\.......;

ENDIF

johnhhtp2
Contributor II

Re: Need help on Call parameter on QMC

Thanks Gabriel , would you please elaborate what needs to be given in parameter name and parameter value in QMC, for the above example.

John

Gabriel
Valued Contributor II

Re: Need help on Call parameter on QMC

Hi,

Goto QMC, select Documents tab -> Source Documents tab then click on the + sign to navigate to the qvw file you want to split the task. Then click on the Edit Task button (it's Pencil like shape) the select Reload tab. Here you will find where you can enter Parameter Name and Parameter Value

johnhhtp2
Contributor II

Re: Need help on Call parameter on QMC

Thanks Gabriel, not sure whether I'm asking  the right question or not, what if 8:00 AM job gets failed,and then I run it manually, how does this gets executed.

John

Gabriel
Valued Contributor II

Re: Need help on Call parameter on QMC

I think you can set the retry number in QMC as well. The job will reload if it fails again & again for the number of retries you entered. Or you can reload manually

When 8:00 AM fail it won't affect the 9:00 AM job