Help files

Data Tables

Data tables contain data in a tabular form (it is the equivalent of two-dimensional arrays in programming). A data table contains rows and columns and each item stored in the data table can be retrieved through its unique row and column number. You can think of data tables as lists: each item of the list is also a list.

There is no direct way to create a data table but there are 2 actions that generate a data table as an output: the “Read from Excel” action and the “Execute SQL Statement” action.

In order to retrieve a specific item of a data table, you will have to use the following notation:

%VariableName[RowNumber][ColumnNumber]%

Keep in mind that “RowNumber” and “ColumnNumber” should be 0 for the first item (row or column), 1 for the second and so on.

For example, if you have a data table that is stored in the variable %MyDataTable%, you can retrieve the first item with: %MyDataTable[0][0]%.

Data Rows

If you loop through a data table with a “For Each” action, the variable that will contain the current iteration’s data, is considered to be a “Data Row”. Data rows are basically lists: they are no different than regular lists (they contain several items, their items can be retrieved through the regular list notation), except for the part that they represent a row in the data table’s scheme. Remember that you can still treat them as if they were lists without any problem at all.