Description

I am getting errors testing linked scripts. Could you help? Could we have additional tips for linking scripts to supplement the documentation on How to Link Scripts’ adding a hyper link where underlined

How to link scripts

Applies to

Transaction 10.X
Query 10.X

Additional Information

What is important to remember is that when linking scripts, the chain starts with a 'leading' script, however, not all the subsequent scripts can be linked to the 'leading' script - This is how it works:

1 - The second script that you want to run needs to be linked to the leading script.
2 - Then the third script needs to be linked to the second script.
4 - If you had a fourth script it would need to be linked to the 3rd script and so on.

Once you have the sequence right, you need to ensure that the parameters on each script (which can be found on your Transaction run screen) show the right sheet name as per defined in your excel file as well as the right file path especially if you want to use a single excel file.

When using the same excel file, you will have to ensure that for each script (except the last script of the chain) you have checked the 'file' box in your Data File Carry Settings. This option is located in your Advanced Run Options.





Under Data File Carry Settings you have 3 options:

1 - File -- check that box if you are using the same result file for your scripts.
2 - Sheet -- check that box if you are using the same sheet for all your scripts
3 - Start and End row -- check that box if all your scripts will always be running the same start and end rows in your excel file