VT_ARRAY

The VT_ARRAY function allows you to perform different actions using arrays or data matrices. Click Add to add a new array call. Select an option from the drop-down menu in the Method field and configure the parameters applicable for that method. You can add as many array calls as you need.

Note

Note: In VT_ARRAY functions, you don’t have to complete the Output variable

There are nine methods available for VT_ARRAY functions. For any method, click Delete to delete a specific array call, click Save to save changes, or click Cancel to go back to the process editor page.

Read the subsections below to learn more about each method and how to configure its parameters.

addRow

The addRow method allows you to add a row at the end of an array.

addRow.	Array method selected.
arrayId.	Enter the id of the array where the row will be added.

clone

The clone method allows you to duplicate an array. Only the structure and content of the array will be copied.

clone.	Method selected.
arrayIdDest.	Enter the id of the array in which the information of the origin array will be copied. If it already contains data, that information will be replaced.
arrayIdOrigin.	Enter the id of the array to be duplicated.

concat

The concat method allows you to concatenate two arrays. Both arrays must have the same number of columns and each column must have the same id number (for example, both arrays must have 10 columns numbered from 1 to 10). No rows are selected for the resulting array.

concat.	Array method selected.
arrayIdDest	Enter the id of the array in which the array resulting from the concatenation will be copied. You can specify one of the arrays as destination. If it already contains data, that information will be replaced.
arrayIdOrigin1.	Enter the id of the first array to be considered for the concatenation.
arrayIdOrigin2.	Enter the id of the second array to be considered for the concatenation.

create

The create method allows you to create a new array.

create.	Array method selected.
arrayId.	Enter an id to identify array to be created.
Columns.	Enter the number of columns to be added to the array.

deleteRow

The deleteRow method allows you to delete a row in a specific array.

DeleteRow	Array method selected.
arrayId	Enter the id of the array in which the row will be deleted.
rowNumber	Enter the number of the row to be deleted.

selectRow

The selectRow method allows you to select a row in a specific array.

arrayId	Enter the id of the array in which a row will be selected.
rowNumber	Enter the number of the row to be selected.
deltaToSelect	Displacement from the selected row. Complete with the respective number.

sort

The sort method allows you to organize the rows in an array applying a sorting criterion to one or several columns.

arrayId.	Enter Id that identifies the array to be sorted.
columnsToSort.	Enter the sorting criterion to be applied to a column. If you want to apply a criterion for more than one column, criteria shall be separated using the character "\|".

unselectRow

The unselectRow method allows you to deselect a row in a specific array. You must complete the arrayId parameter. Enter the id that identifies the array in which a row will be deselected.

updateRow

The updateRow method allows you to update the information in a row within a specific array.

arrayId	Enter the id that identifies the array in which a row will be updated.
rowNumber	Enter the number of the row to be updated.
delimiter	Enter the delimiting character that separates the data you want to split.
columnsToUpdate	Enter the number of columns to be updated that are separated by the delimiter.
values	Enter the values to be updated in each column, separated by the delimiter.

In this section:

Veritran Docs