The Create Array action is used to create an array, which can then be used as a place holder for data in subsequent task steps. An array is a specialized kind of variable that has multiple rows. This action supports multi-dimensional arrays up to three dimensions.
A one-dimensional array has one column, a two-dimensional array has multiple columns, and a three-dimensional array could be thought of as having multiple pages, each containing multiple rows and columns.
From the Task Builder Available Actions pane, open the Variables folder and double-click the Create Array action or drag it into the Steps pane.
In the Array Name box, enter a name for the array. Be sure the name is unique and does not conflict with any BASIC scripting keywords such as date, day, week, etc. One safe way to do this is to always include identifying characters, such as AR, in array names (for example, DayAr).
If the array is to have only one dimension, enter the number of rows in the One dimension box.
If the array is to have multiple dimensions, select the applicable specification and enter the dimensions in the boxes provided.
If you want to include a description for the array, enter it in the Description box. The description will be displayed in the Variables tab of the Task Builder debug window.
To specify the variable type, click the Advanced tab and select from the following:
Auto: AutoMate will auto-detect whether the array contains numbers or text. The array will adapt to the proper type when possible depending on the operation being performed.
Text: The array will always be treated as text regardless of its contents. An error will be generated if an operation is attempted that is only valid for numbers.
Number: The array will always be treated as a number regardless of its contents. An error will be generated if an operation is attempted that is only valid for text.
To set the Description tab properties, refer to Description Tab Options.
To set the Error Causes and On Error tab properties, refer to Step Error Handling.
When finished, click OK to save settings and close the properties dialog window.
Adding Task Steps
Create Array Action