Like variables, arrays are used to represent data in a task that may be different each time a task runs. But unlike standard variables, arrays can contain multiple rows and optionally multiple columns. You may want to think of an array as nothing more than a list, such as a shopping list, to-do list, birthday list, etc. All items in an array, like the items in a list, have a position somewhere between first and last. Items are numbered from lowest to highest in arrays, therefore, they are accessed by number. For example, to retrieve the element in Row 2, Column 10, the following expression would be entered:
An array can be used to store a list of data read from a text file or other system containing customer data. For instance, if there are 10 customers, the array would need to have 10 rows. If the data consisted of first name, last name, and company name it would need 3 columns and would need to be a two dimensional array. An array can also be a simple list of text or numeric values (i.e. multiple rows of data, only one column), this is called a one dimensional array.
An array with only one dimension is linear. In other words, it contains a list of data that can be referenced by a number. For example if my one dimensional array named myArray had 3 values, then the syntax would be:
myArray(1) = value1
myArray(2) = value2
myArray(3) = value3
In a two dimensional array, you have both rows and columns, such as a spreadsheet. You would then need to reference a cell by row and column, like the expression below which references row 1, column 5.
To create an array, use the Create Array action. You give your array a name a set it’s size. You also choose whether you want your array to be a one dimensional array or two dimensional array, sometimes called a matrix.
To Set a value in an array, use the Set Variable action and for the variable name specify arrayname(row, column [only if two dimensional])
NOTE: The code below can be copied and pasted directly into the Steps pane of the Task Builder.
<AMARRAY NAME="myarray" TYPE="TEXT" ROWS="3" />
<AMARRAY NAME="myarray" TYPE="TEXT" ROWS="%FileCount('c:\test\')%" />
<AMLOOP TYPE="FOLDER" FOLDER="c:\test\" RESULTVARIABLE="thefilename">
<AMINCREMENTVARIABLE RESULTVARIABLE="counter" />
<AMLOOP TOTALLOOPS="%UBound(myarray, 1)%" RESULTVARIABLE="counter">
Create Array action
Variables | Constants | Arrays | Datasets | Expressions | Shared Arrays | Shared Datasets | Shared Variables | Functions/Extended Functions | Expression Builder