When using a variable for text replacement in the script or in an expression, the following syntax is used:
For numeric variable expansions, the following syntax is used:
It always yields a valid decimal-point representation of the numeric value of the variable, possibly with exponential notation (for very large/small numbers). If variablename does not exist or does not contain a numeric value, it will be expanded to 0 instead.
LET X = 7/2;
The dollar-sign expansion $(X) will
LOAD * from $(MyPath)abc.csv;
Data will be loaded from C:\MyDocs\Files\abc.csv.
SQL SELECT * FROM table1 WHERE Year=$(CurrentYear);
In this example, all .
LOAD * FROM[.\file1.txt];
Concatenate LOAD * FROM[.\file2.txt];
Concatenate LOAD * FROM[.\file3.txt];
Expanding variables in alternate states
The variable has only one value, and this is used in all alternate states. When you expand a variable the value is also the same, independent of where it is made, and the state of the object.
If the variable is a calculated variable, that is, the definition starts with an equals sign, the calculation is made in the default state, unless you specify an alternate state in the variable definition.
If you have a state named MyState, and a variable named vMyVar:
The variable definition content, with an explicit reference to the alternate state name, determines in which state the variable content will be evaluated.