Difference between Loop-Reduce vs Script Parameters in the Reload Tab

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In QMC under the source document tab and under the Reload - we have "Script Parameters", which says "A separate document will be created for each value. If selecting a field from the document, all values in that field will be used."

Parameter Name

The variable created in the QlikView script, which will be used in the script execution of the document.

Parameter Value

The value(s) that will be assigned to the variable in the Parameter Name field. The value(s) will be used to create the document. To use a sequence of data, enter the start and stop values separated with a '-' (dash). To separate single values or sequences, enter a ';' (semi-colon).

Or

To select a specific field in the document and create a separate document for each value in that field, click the Open Document button, and select the desired document field. The values present at the start of the execution will be used. If field values change during the execution, such changes will not be reflected in the new documents. The use of this field will suppress the use of any value in the Parameter Name field.

How this differs from the Loop and Reduce in the Reduce Tab?

Re: Difference between Loop-Reduce vs Script Parameters in the Reload Tab

Anonymous — Sat, 03 Sep 2016 03:00:52 GMT

Hi,

Has anyone looked into this?

Thanks

Re: Difference between Loop-Reduce vs Script Parameters in the Reload Tab

hectorgarcia — Fri, 28 Apr 2017 19:25:02 GMT

yes I posted a example in What is the use of Script Parameters in QMC?

topic Re: Difference between Loop-Reduce vs Script Parameters in the Reload Tab in QlikView

Difference between Loop-Reduce vs Script Parameters in the Reload Tab

Parameter Name

Parameter Value

Re: Difference between Loop-Reduce vs Script Parameters in the Reload Tab

Re: Difference between Loop-Reduce vs Script Parameters in the Reload Tab