Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Is there a way to have Publisher set a variable to a value in a QlikView File.
Thank You,
Michael Stoler
Yes, you can set a variable in the parameter section of the reload tab when editing the task in QEMC.
Yes it can. On the Reload tab of publisher task, you'll see two fields, Parameter name and Parameter value under "Script Parameters". You can set more than one variable by separating the variables using semi-colon ";".
Hope that helps.
Vikas
Hi vikasbhasin,
how do you get it work to pass two parameters at the publisher frontend?
It works fine with two parameters when I start a batch script but not in the publisher frontend: Here´s my configuration:
Parameter name: vBatchPlant;vEnviroment;
Parameter value: 104;PROD;
Do you have an idea?
Kind regards,
P. W.
Peter,
Based upon our implementation attempts, it seems that the publisher "Parameter Name" is meant to be a single variable name, and then publisher will iterate one reload per value specified in the "Parameter Value" field. That's our interpretation, we've not tried to get confirmation.
We have reasons where we sometimes want to pass in multiple variables to a reload task, but we aren't looking for publisher to iterate multiple times--we just want to pass in more than one variable to a single reload operation. To do this, we built a small routine which allows us to pass a text string (in the parameter value field) that has one or more name/value pairs, so we can send in as many parameters as we need.
Sample attached, in case you/others find it of value. It's worked for our purposes.
- Brett
Hello Brett,
in the meanwhile I had a similar looking idea to solve the problem. My version is quite more simple and absolutly not documented. Many thanks for your good solution!
Kind regards,
Peter W.