> For the complete documentation index, see [llms.txt](https://docs.tabula.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tabula.io/data-flows/tools-nodes/filtering-and-sorting/filter.md).
# Filter
Filters rows based on the specified condition
## 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.
