Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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
Partner - Specialist III
Partner - Specialist III

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

Anonymous
Not applicable
Author

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
Partner - Specialist III
Partner - Specialist III

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

Anonymous
Not applicable
Author

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
Partner - Specialist III
Partner - Specialist III

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