Find Row
Find the row of a data table.
Last updated
Visualyze Documentation
Find the row of a data table.
Last updated
Find the row or list of rows in which an input value is found from the data table and store it in a variable.
Input : DataTable Variable
The DataTable in which the input value is to be searched for finding a row or list of rows.
Value : String Argument
The input value is to be searched from the data table for finding a row or list of rows.
Method :
The method to find row
First - Get the first occurrence of value. It will return the first row that contains the input value.
AtIndex - Get the value in the specified index if there are multiple search results. It will return a row of a specified index if the input value is found in more than one row.
All - Get all values. It returns a list of rows in which the input value is found.
Index : Integer Argument
The index of the particular row from a list of rows in which the input value is found.
Column Name : DynamicSearchString
The name of the column in which the input value is to be searched.
Text - The full name of the column to be sorted.
Regex - The regex is used to find matching column names to be sorted.
Wildcard - The character that is used for search matching column name. The asterisk (*)and the question mark (?) are used as wildcard characters. The asterisk represents zero or more characters in a string. The question mark represents any one character.
The Text, Regex and Wildcard search methods are supported.EditDistance is not supported.
Column Index : Integer Argument
The index of the column in which the input value is to be searched. If this property is set then the Column Name property is ignored.
Output : Object Variable
The variable that stores the resulting data table that contains the data row or a collection of data rows of the specified input value found in the data table.
Found : boolean Variabl
The variable that stores the row number or number of rows of specified input value found in the data table.
