| Variable
|
This variable name is created in the input spreadsheet, if the Variable Type is Spreadsheet Variable. Because these variables are written back to the input spreadsheet, existing variable names cannot be used
Caution: Do not start variable names with a dollar sign ($)
|
| ArrayMax
|
The value returned or fetched from the array, such as 0.3 or ”Hot.” If text with weights is saved into an Array, the weights determines the minimum value and maximum value, and return the correct text. For text without weights, the minimum value and maximum values are calculated based on the alphabetical order
Push("COUNTER", "ONE")
Push("COUNTER", "TWO")
Push("COUNTER", "THREE")
Min_Variable = ArrayMin("COUNTER", 1)
; Returns text value of ONE
Max_Variable = ArrayMax("COUNTER", 1)
; Returns text value of TWO. Alphabetical order is ONE THREE TWO
|
| Array Name
|
Name of array that contains values. Array name is created by calling Push Array
|
| n
|
This is the array number, which starts with 1. If there are 3 elements in the array, such as Hot, Cold, and Ignore; then array number for Hot would be 1 or 3. If the
Min option button is selected, array number is 1. If the
Max option button is selected, array number is 3
|
| Variable
|
- Type: Select the type of variable that should be created by the rule
- Spreadsheet Variable: Creates a new variable in the input spreadsheet
- Temporary Variable: Creates a variable to store an intermediate result. These variables get discarded and are not stored in the input spreadsheet
- Min/Max: The options in this box control the order that the array is read based on the numeric value of the array element. Values can be fetched from the array based on the highest or lowest numeric value
- Min: Fetch data from the array from smallest to largest numeric value
- Max: Fetch data from the array from the largest to smallest numeric value
|
