Search for a value action

Enables you to search for a specific value in a table and return the row or column numbers in which the entry occurs.

When you search for a value using the Search for a value action, it will either return:
  • A list of all the positions from the Data table where the search matched
  • An empty list if the value is not found.
Consider a scenario where you have a Data table called EmpDetails. If the cell position of table EmpDetails is 214.5, then you can get value of the cell by using demoTable[214][5].

Settings

  • Click the Enter database name drop-down and select an existing data table.

    If there is no existing data table, click the Create variable icon to create a variable.

  • Click the Enter value to search for drop-down menu to select a variable.
  • (Optional) Select the Match case check box if the search term is case sensitive.
  • (Optional) Click Assign result to variable drop-down to select a variable that you want to assign the value that the search returns.

Consider an example where you want to search for an entry called abc that is available at the fourth row and third column of a table variable. When you use the action, it returns 3,2 as output. As the index number for the row and column starts with zero, the values in the output indicates the fourth row and third column.

So it is a x,y structure list where 'x' refers to Row index and 'y' refers to Column index, with base 0 criteria.