Adding an Array Function (Release 9.2.7)

You can add multiple array functions to a logic extension. When you add an array function to the logic extension, the Array Function panel is displayed on the right.

The following array functions are available in the Array panel: get row, append row, and update row. You can also choose to add a system generated While statement template to process the array data in a loop.

To add an array function:

1. On the design page, hover over the location where you want to add the array function and then click the + icon. Select Array Function from the Action menu. The system displays the Array Function panel on the right.
2. In the Array Function panel, edit the label and enter the description for the array function.
3. In the Array drop-down menu, the system displays the arrays that are defined in the Data Structure tab. Select the required array. The system displays the columns of the selected array. See Defining Data Structure
   Note: This is a required field.

   When you select an array from the Array drop-down menu, the system displays the Array Function drop-down menu and the Iterate Array button.

4. From the Array Function drop-down menu, select the required function.
   • get row: Use this function to load a particular row of data into the members of the array defined in the Data Structure or the Variables tab. When you select the get row function, the system displays the Index drop-down menu to control which row of the array is returned. This Index drop-down contains all the numbers available in the Data Structure and Variables tab for selection or you can also enter an integer for the value (the index of an array starts at zero).
   • append row: Use this function to append a new row at the end of an array.
   • update row: Use this function to update a row. When you select the update row function, the system displays the Index drop-down menu to control which row of the array is updated. The Index drop-down contains all the numbers available in the Data Structure and Variables tab for selection or you can enter an integer for the value (the index of an array starts at zero).
5. Without selecting an option from the Array Function drop-down menu, you can click the Iterate Array button to create a counter and a While loop to iterate over the array. This button enables you to add a system generated While statement template to process the array data in a loop. This template consists of a While statement with a counter,a get row array function, and an assignment block that increments the array counter. You can change or define mappings for this assignment block using the Assignment Builder window.
   Note: When you click the Iterate Array button, a counter array with the name <array name>Counter is added in the Variables tab.