# Filter

## Overview

The Filter Node allows you to filter your dataset based on specific conditions or custom formulas.

## **Settings**

#### **Find rows where**

The "Find Rows Where" property allows you to define the conditions for filtering rows in your dataset. There are two options for creating conditions:

**1. Predefined Operators**

Using predefined operators, you can easily set up conditions based on column values and comparison operators. Follow these steps to create a condition:

1. Select the column you want to use as a basis for the condition.
2. Choose a comparison operator (e.g., equal, contains, more, etc.) depending on the column's data type.
3. Enter a value to compare with the selected column's values.

To add more conditions, click the "Add Condition" button. You can combine multiple conditions using the following logical operators:

* **And**: Both conditions must be true for a row to pass the filter.
* **Or**: At least one of the conditions must be true for a row to pass the filter.

You can also add a new group of conditions. Click the "Add Condition" button and select "Add group".

**2. Custom Formula**

To use a custom formula, enable the "Custom Formula" toggle. With this option, you can define any condition that returns a boolean value (true or false).

#### **Action**

The "Action" property lets you choose what to do with rows that pass the filter conditions. There are two available options:

1. **Keep Filtered**: Only keep rows that meet the filter conditions in the dataset.
2. **Remove Filtered**: Remove rows that meet the filter conditions from the dataset.


---

# 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.tomat.ai/data-transformation/transforms/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.