LookUp Data Table

Search the specified value in the data table.

Search the provided lookup value in the specified data table and returns the value and the row index at which it was found.

Input

• Input : DataTable Variable The data table in which the lookup value is to be searched.

• Lookup Value : String Argument The value you want to search between the lookup column and target column of each row in the specified data table.

• Matching Method : Specifies the method used for matching the user-specified look-up value with each of the row values in the specified column. The available options are:-

  • Text - Checks for the exact match for the lookup value.

  • Regex - Checks for the matching value with the lookup value.

  • Wildcard - Specifies the character that is used to search for matching values with the lookup value.

When multiple matches are found while using Search Methods, only the first match is considered.

Lookup Column

• Column Index : Integer Argument The index of the column in which the lookup value search starts in each row of the data table. The column coordinate for searching lookup value starts from the lookup column index. If this property is set, then both Column Name and Data Column are ignored.

• Column Name : DynamicSearchString The name of the column in which the lookup value search starts in each row of the data table. The column coordinate for searching lookup value starts from the lookup column name. If this property is set, then both Column Index and Data Column are ignored.

  • Text - The full name of the column that is to be sorted.

  • Regex - The regex is used to find matching column names to be sorted.

  • Wildcard - The character that is used to search for 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.

  • Edit Distance - Specifies the minimum number of single-character edits required to change the given column name to the matching column name which should be less than the value in the Max Edit Distance field. The activity takes the column name with min edit distance with the user-specified Look-up column name.

• Data Column : Object Argument A Data Column object in which the lookup value search starts in each row of the data table. The column coordinate for searching lookup values starts from the lookup data column. If this property is set, then both Column Name and Column Index are ignored.

When multiple matches are found while using Search Methods, only the first match is considered.

Target Column

• Column Index : Integer Argument The index of the column in which the lookup value search ends in each row of the data table. The column coordinate for searching lookup value ends at the target column index. If this property is set, then both Column Name and Data Column are ignored.

• Column Name : Dynamic Search String

  The name of the column in which the lookup value search ends in each row of the data table. The column coordinate for searching lookup value ends at the target column name. If this property is set, then both Column Index and Data Column are ignored.

  • Text - The full name of the column that is 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.

  • EditDistance - Specifies the minimum number of single-character edits required to change the given column name to the matching column name which should be less than the value in the Max Edit Distance field. The activity takes the column name with min edit distance with the user-specified target column name.

• Data Column : Object Argument The object of the data column in which the lookup value search ends in each row of the data table. The column coordinate for searching lookup value ends at the target data column. If this property is set, then both Column Name and Column Index are ignored.

if the target column is not set then the cell value is null.

Output

• Cell Value : Object Variable The value found in the cell that has the Row coordinates specified in the Row Index property and the Column coordinates specified in the Target Column property Category.\
• Row Index : Integer Variable The index of the row in which the lookup value found. which is the row coordinate of lookup value.