# Apply Row Filter

The Apply Row Filter activity allows you to keep or remove rows from a DataTable based on specified filter conditions.

### Input

* **Input** : [`DataTable Variable`](https://docs.visualyze.ai/getting-started/rpa-studio/variables#datatable)![](https://1935494318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M927xRZSEM57y2sBcm3%2Fuploads%2Fgit-blob-20e90e25afa096ee0833e242a7763776d12b4591%2Fimage.png?alt=media)\
  Specifies the DataTable that is to be filtered.

### Configure

* **Filters** : 

  This property allows you to define the filter conditions to be applied to the DataTable. You can use variables as filter values in the filter conditions. Make sure to prefix variables with '$' when adding them to the filter condition.<br>

  <figure><img src="https://1935494318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M927xRZSEM57y2sBcm3%2Fuploads%2FFYa0KMjffwkohRsyEFmI%2Fimage.png?alt=media&#x26;token=427d88f4-d8fe-486b-af46-518a0685bf4d" alt=""><figcaption><p>Filter DataTable window</p></figcaption></figure>

{% hint style="info" %}
***Information*** :

* The '+' button is used to create a new filter condition in the filter window.
* The 'x' button is used to remove a filter condition from the window.
* Each condition requires a column name, operator, and value to filter the DataTable.
* Variables can be represented as $VarName.
* There is a dropdown with options to either keep or remove the filtered records from the DataTable.
* The 'Preview' button displays the filtered DataTable in the grid below the filter conditions.
* The 'Clear' button removes all filter conditions except the default condition.
  {% endhint %}

### Output

* **Output:** [`DataTable Variable`](https://docs.visualyze.ai/getting-started/rpa-studio/variables/activity-variables#datatable)\
  The variable that stores the resultant filtered data table.

By utilizing the Apply Row Filter activity effectively, you can easily filter rows in a DataTable based on specified conditions, allowing you to extract and work with the relevant data in your automation process.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.visualyze.ai/rpa-studio/data/datatable/datarow/apply-row-filter.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.