# A new an improved way to Filter Rows!

**URL:** <https://community.parabola.io/t/a-new-an-improved-way-to-filter-rows/2428>\
**Category:** Announcements\
**Created:** [July 12, 2022, 9:03pm UTC](https://community.parabola.io/t/a-new-an-improved-way-to-filter-rows/2428 "2022-07-12T21:03:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![brian](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/brian/32/11_2.png) [@brian](https://community.parabola.io/u/brian)\
**Post date:** [July 12, 2022, 9:03pm UTC](https://community.parabola.io/t/a-new-an-improved-way-to-filter-rows/2428/1 "2022-07-12T21:03:25Z")

</div>

Hey all!

We’ve made two new updates to the **Filter Rows step** that we think we add even more power to your flows.

## Add multiple criteria to single filter

In the past, if you had a large list of criteria that you had to filter against, such as email domains to remove, you needed to add an individual rule for each criteria.

Now, the `contains`, `not contains`, `is equal to`, and `is not equal to` filter operations will **accept multiple criteria** fields.

 ![Screen Shot 2022-07-12 at 1.53.02 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/b/b291bb8dc83139b192c0ca53d2df8539f52adc83.png)

## Use merge tags in a filter criteria

Previously, when you needed to compare one column to another, and the filter based on that comparison, you would use an Insert If Else Column step to perform the comparison, followed by a Filter Rows step to then filter based on that comparison (also creating an extra temporary column in the process).

Now, the Filter Rows step will accept **merge tags**. Enter any column name, wrapped in {curly braces}, to compare columns inside of a filter.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/8/83bfff0d5c74f4353632ef2f2225c47a034af19b.png)

We hope these changes will help super charge your flows!

---

<div class="post-metadata">

**Author:** ![Jacob\_Gorthy](https://avatars.discourse-cdn.com/v4/letter/j/e8c25b/32.png) [@Jacob\_Gorthy](https://community.parabola.io/u/Jacob_Gorthy)\
**Post date:** [July 13, 2022, 4:48pm UTC](https://community.parabola.io/t/a-new-an-improved-way-to-filter-rows/2428/2 "2022-07-13T16:48:00Z")

</div>

This is an absolutely amazing improvement to filters 🥳

---

<div class="post-metadata">

**Author:** ![Mark\_Berry](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/mark_berry/32/2159_2.png) [@Mark\_Berry](https://community.parabola.io/u/Mark_Berry)\
**Post date:** [December 30, 2023, 8:00am UTC](https://community.parabola.io/t/a-new-an-improved-way-to-filter-rows/2428/3 "2023-12-30T08:00:13Z")

</div>

Can the filter rows be used to compare and filter column data from 2 separate tables?

---

<div class="post-metadata">

**Author:** ![Emory\_Stainbrook](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/emory_stainbrook/32/1772_2.png) [@Emory\_Stainbrook](https://community.parabola.io/u/Emory_Stainbrook)\
**Post date:** [January 2, 2024, 6:37pm UTC](https://community.parabola.io/t/a-new-an-improved-way-to-filter-rows/2428/4 "2024-01-02T18:37:19Z")

</div>

Hi @Mark_Berry - The Filter rows step can only work with one input at a time. It sounds like our [Find overlap step](https://parabola.io/transform/find-overlap) may be what you’re looking for instead. It can be used to find matching data between two tables.

Let me know if you have any questions!