Everything contained between two percentage marks "%" is evaluated, and replaced with the variable's value.


List

Let's say %MyList% is a list variable with 10 items. 


%MyList[0]% -> 1st list item

%MyList[1]% -> 2nd list item

%MyList[2]% -> 3rd list item

.

.

.

%MyList[9]% -> last list item



In case the list index (0,1,2,...) is stored into the variable %index%, then


If %index% = 0 -> %MyList[index]% -> 1st list item

If %index% = 1 -> %MyList[index]% -> 2nd list item

If %index% = 2 -> %MyList[index]% -> 3rd list item

.

.

.

%MyList[MyList.Count-1]% -> last list item




DataRow

DataRow variables usually occur when we iterate through a DataTable variable using the "For Each" action.


DataRows behave in a way that is much like Lists:


Let's say %MyRow% is a DataRow variable with 10 items. 


%MyRow[0]% -> 1st row item

%MyRow[1]% -> 2nd row item

%MyRow[2]% -> 3rd row item

.

.

.

%MyRow[9]% -> last row item



In case the row index (0,1,2,...) is stored into the variable %index%, then


If %index% = 0 -> %MyRow[index]% -> 1st row item

If %index% = 1 -> %MyRow[index]% -> 2nd row item

If %index% = 2 -> %MyRow[index]% -> 3rd row item

.

.

.

%MyRow[MyRow.Count-1]% -> last row item


DataTable

Let's say %MyTable% is a data table with 10 rows and 10 columns.


%MyTable[0][0]% -> cell of 1st Row and 1st Column

%MyTable[0][1]% -> cell of 1st Row and 2nd Column

%MyTable[0][2]% -> cell of 1st Row and 3rd Column

.

.

.

%MyTable[1][0]% -> cell of 2nd Row and 1st Column

%MyTable[1][1]% -> cell of 2nd Row and 2nd Column

%MyTable[1][2]% -> cell of 2nd Row and 3rd Column

.

.

.

%MyTable[9][9]% -> last cell (bottom right corner of the table)



In case the Row Index (0,1,2,...) is stored into the variable %RowIndex% and Column Index (0,1,2,...) is stored into the variable %ColumnIndex%, then


If %RowIndex% = 0 & %ColumnIndex% = 0 -> %MyTable[RowIndex][ColumnIndex]% -> cell of 1st Row and 1st Column

If %RowIndex% = 0 & %ColumnIndex% = 1  -> %MyTable[RowIndex][ColumnIndex]% -> cell of 1st Row and 2nd Column

If %RowIndex% = 0 & %ColumnIndex% = 2 -> %MyTable[RowIndex][ColumnIndex]% -> cell of 1st Row and 3rd Column

.

.

.

If %RowIndex% = 1 & %ColumnIndex% = 0 -> %MyTable[RowIndex][ColumnIndex]% -> cell of 2nd Row and 1st Column

If %RowIndex% = 1 & %ColumnIndex% = 1  -> %MyTable[RowIndex][ColumnIndex]% -> cell of 2nd Row and 2nd Column

If %RowIndex% = 1 & %ColumnIndex% = 2 -> %MyTable[RowIndex][ColumnIndex]% -> cell of 2nd Row and 3rd Column

.

.

.

%MyTable[MyTable.RowsCount-1][MyTable.Columns.Count-1]]% -> last cell (bottom right corner of the table)



*For a more detailed explanation on the use of percentage sign, refer to the following article: https://support.softomotive.com/solution/articles/35000088650-usage-of-the-character