Find a row by a key value and return a column from it, like VLOOKUP
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Table Variable tableName | variable | Required | — | — |
Look In Column lookupColumn | string | Required | — | Column to search for the value |
Value to Find searchValue | expression | Required | — | — |
Return Column returnColumn | string | Optional | — | Column to return from the matching row. Leave empty to return the whole row. |
Match Case caseSensitive | boolean | Optional | false | — |
Value If Not Found defaultValue | string | Optional | — | — |
Output Variable outputVariable | variable | Optional | LookupResult | — |
Output
LookupResultObjectLookup outcome and the value found
FoundBooleanValueStringRowObjectMatchCountNumber
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Add table column
Add a new column to an existing data table
Add table row
Add a new row to a table
Clear table
Remove all rows from a data table
Convert table to text
Turn table data into a text format like CSV
Convert to Table
Convert API response data to a table format for Excel
Create table
Create a new table to store rows and columns of data