# Fetch specific row

**URL:** <https://community.automationedge.com/t/fetch-specific-row/17695>\
**Category:** Process Studio\
**Tags:** rpa\
**Created:** [March 7, 2026, 12:48pm UTC](https://community.automationedge.com/t/fetch-specific-row/17695 "2026-03-07T12:48:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![akash](https://avatars.discourse-cdn.com/v4/letter/a/a5b964/32.png) [@akash](https://community.automationedge.com/u/akash)\
**Post date:** [March 7, 2026, 12:48pm UTC](https://community.automationedge.com/t/fetch-specific-row/17695/1 "2026-03-07T12:48:46Z")

</div>

Which method is used to fetch only a specific row from the given data?

---

<div class="post-metadata">

**Author:** ![AETrainings](https://avatars.discourse-cdn.com/v4/letter/a/2acd7d/32.png) [@AETrainings](https://community.automationedge.com/u/AETrainings)\
**Post date:** [October 5, 2026, 6:57am UTC](https://community.automationedge.com/t/fetch-specific-row/17695/2 "2026-10-05T06:57:25Z")

</div>

In AutomationEdge Process Studio, the method used to fetch only a specific row depends on whether you are extracting data from a **UI table** (Web or Desktop) or filtering a **workflow data stream** :

* * *

**1. Extracting a Row from a Web or Desktop UI Table**

If you are using table steps such as **GUI: Web Table** or **GUI: Get Table Data** :

- **Action / Selection Option:** Set the option to **One Row With Specific Columns**.
- **Configuration:** Enable and specify the target row number in the **Row Index** field.

* * *

**2. Fetching a Specific Row from a Data Stream**

If you already have data flowing through a Process Studio workflow pipeline:

- **Sample rows Step:** Extracts specific individual row numbers or row ranges (e.g., row `5` or `5..10`) directly from the incoming stream.
- **Filter Rows Step:** Filters and passes specific rows based on conditional checks or key value matches.

* * *

**3. Reading a Specific Row from Files (e.g., Excel / CSV)**

- **Microsoft Excel Input Step:** Set the **Start row** to the desired row index and set **Limit** to `1` to fetch only that specific row
