Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have two Two table A,and B and a variable var
if var value is 1 then load the table A else load the table B
any suggestion on this???
May be something like this:
IF $(Var) = 1 then
LOAD fieldNames
FROM TableA;
ELSE
LOAD fieldNames
FROM TableB;
ENDIF
Go to the Layout tab for each chart. On there you will find a Show option in the middle on the right-hand side. For table A set something like this in there:
var = 1
For table B something like this:
var <> 1
If you mean in your script, you could work with a CASE:
May be something like this:
IF $(Var) = 1 then
LOAD fieldNames
FROM TableA;
ELSE
LOAD fieldNames
FROM TableB;
ENDIF
Or in your script:
IF var = 1 THEN
TableA:
LOAD * FROM TableSource (options);
ELSE
TableB:
LOAD * FROM OtherTableSource (options);
END IF
You can add an inputbox couple to var on a sheet to control the script code execution path.
Peter