Retrieves the first row in that column, there is an optional parameter row index you can pass as well when you need to have value from a particular row index
country = getTableColumn("100\_Sales\_Records", "Country", 1)
By default this function will give different column values for each request , but if you want to get always the same value , you need to pass the third parameter row index
team = getTableColumn("TeamDetails", "teamName", 2)
| | ------------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **getTableRow(tableName, columnNames)** |Retrieves the first row of each column given. columnNames separated by semicolon . Next call will give the second row and so on.
getTableRow("100\_Sales\_Records", "Country;Region")
| | **getTableRowByColumn(tableName, matchColumnNames, matchColumnValues, outputColumnNames)** |Retrieves the first row of column values that matches given column names and values. User can also supply the output columns to be retrieved , but it is optional . In case of multiple input, the values of matchColumnNames, matchColumnValues and outputColumnNames should be separated by a semicolon
This function will always give the values of the columns consistently, means you can have the same set of values for every call based on the criteria
getTableRowByColumn(“100\_Sales\_Records”, “Region;Country”, “Europe;Russia”)
| | **setTableColumn(tableName, columnName, columnValue, uniqueFlag)** |Set a value to a single column of the table. Value of uniqueFlag can be 0 or 1
setTableColumn("100\_Sales\_Records", "Country","USA", "0")
| | **setTableRow(tableName, columnNames, columnValues, type)** |Set the values of a row in a table(columnNames and columnValues separated by semicolon). Value of type can be ROW or UNIQUE or STACKED
setTableRow("100\_Sales\_Records", "Country;Region", "Japan;Nagasaki", "ROW")
| | **updateTableColumn(tableName, columnName, columnValue, uniqueFlag, rowIndex)** |Update a value to a single column of the table by row index. Value of uniqueFlag can be 0 or 1
updateTableColumn("100\_Sales\_Records", "Country","India", "0", "1")
|