run seperate tabs in script based on variable

[hopkinsc]

Hi all,

If i had several tabs in the script but only want to run specific ones based on a variable how would i do this?

i.e.

1 = QVD

2 = DB

LET vScriptMode = 1

so i would want the QVD load tabs to run.

Thanks

[alexandros17 · Accepted solution]

read the variable from an external source (e.g. xlsx file) and depending on its value write:

If myVar='QVD' then

... your script in qvd page

End if

[preminqlik]

let vScriptmode=1;

if $(vScriptMode)=1

then

(tab1 script)

else (tab2 script)

end if ;

[#4]

Add in the tab "exit script;"

ex.

Tab1

**********************

IF $(vScriptMode) = 1 THEN

....

Load Statemets of tab1....

....

ELSE

Tab2

*************

....

Load Statemets of tab2....

....

ENDIF