Documentation

Tablesearch function

This function is used to search data in the table. This function expects two parameters.
First parameter: alias name or variable name in which table data is stored.
Second parameter: table data which user wants to check whether this data is present inside the specified table or not.
The output of this function will be stored in a variable defined in the Element key section. If the data is found in the table it will return true else it will return false.

Select SET command from the action dropdown and provide a variable name in Element key, edit parameter section and click on Form, select functions from the dropdown and select TABLE_SEARCH function. Provide alias name and key to be searched.

After completing the step, it will look as below:

Example: ${__tablesearch(table_rows,Germany)}

Here, table_rows is an alias (variable) in which table data is present. This table data can come from GETTABLE command, GETDBDATA command, loadexcelfile function or from pdftable function. In the above example, Germany is the data(key) to be searched in this table.

If the specified key/data is found in the table it will return true else it will return false in the the variable defined in Element key.

Was this page helpful?