Search for a value action
- Updated: 2025/05/15
Search for a value action
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 is available..
- A list of all the positions from the Data table where the search matched
- An empty list if the value is not found.
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 that holds the value that you want to search.
If there is no existing variable that holds the value that you want to search, click the Create variable icon to create one.
- (Optional) Select the Match case check box if the search term is case sensitive.
- Click Assign result to variable drop-down
to select a variable that you want to assign the value that the search returns.
If there is no existing variable, click the Create variable icon to create one.
Consider an example where you want to search for an entry called
August_sales
that is available at the fourth row and third column of
a table variable. When you use the Search for a value
action, the output list will have length 1 and value as
3,2
. As the index number for the row and column starts with zero,
the values in this output are indicated by the fourth row and third column. Similarly,
if August_sales
is also present at fifth row and fourth column, the
output list will have length 2, with the values 3,2
and
4,3
.
So it is a x,y structure list where 'x' refers to Row index and 'y' refers to Column index, with base 0 criteria.