Help Centre › Functions & Formulas
This article describes the RPA Data functionality to find a row in memory data.
For a full list of available functions, please read DATA functions.
Description
The DATA Find a row in memory data function allows you to find a row in memory data.
Setting it up
To use the DATA Find a row in memory data function, follow these instructions:
{{popups:rpas/add:action=data-row}}
Once on a process map:
- Navigate to the process where you would like to add the DATA Find a row in memory data function
- Click on the green button’s drop-down (right side of the green button labelled “Process”)
- On the menu that appears, click on the “+ Activity” item
- From here you can select the DATA Find a row in memory data option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Variable (source) | Yes | Text | - | Variable containing the data to search |
| Variable (result) | Yes | Text | - | Variable to store the found row |
| Return row number | No | Switch | Off | Return the row number instead of row data |
| Zero based result | No | Switch | Off | Start counting from zero |
| Field / Operator / Value filters | Yes | Table | - | Search criteria |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Object/Number | The matching row data or row number |
Errors
| Error | Description |
|---|---|
| Not found | No row matching the criteria was found |
Tips
- Finds a specific row in memory data by field values
- Enable Return row number to get the index instead of data