Merge variable via script in parallel query execution

[Private_Member_24235]

Dear all,

I have enabled parallel query execution within my design studio application by creating different processing groups ( GR_1, GR_2, GR_3, GR_4) and set the "merge variable" to false.

When executing the application, the user is forced to enter each of the variables four times now, which is not user-friendly.

Is there an script to bring the variables together again, to "merge" again?

Any ideas would be great. Thank you in advance.

Best regards,

Stefanos Leon from Munich/Germany

[IngoH · Accepted solution]

Hello Stefanos,

you would have to loop through the variables from DS_1, retrieve the values, and you can then "copy" them to the variable on DS_2.

Ingo

[Private_Member_24235 · Accepted solution]

Hi Ingo,

thanks for your reply. Where do I have to do this? OnStartup? Which script command I have to use for looping from one DS to another or several other DS?

Thanks in advance.

Best regards,

Stefanos

[IngoH · Accepted solution]

Hello Stefanos,

you would do that on variable initialization and as I mentioned above you would loop through the variables from one data source and copy the values over to the second data source.

I am sure you can find the details on how to create a loop and how to read a value and how to set a value for a variable in the documentation

regards

Ingo Hilgefort, Visual BI