Filter rows

The Filter rows step allows you to cut down your dataset by keeping or removing rows based on specific conditions. 

Building challenge

  • Remove any rows from the sales file where units are equal to zero, or the status is equal to Cancelled or Refunded.
  • Keep any rows from the inventory file where SKU does not contain RETIRED.

To check your work, take a look at this quick video.

How to use the step

  1. Drag a Filter rows step onto the canvas
  2. Specify whether you’d like to Keep or Remove rows of data 
  3. Set filter conditions: You can filter by various conditions such as whether column values are blank, equal, contain certain values, or meet certain numerical thresholds.
    • Note: You can combine multiple filtering conditions using AND/OR logic to target rows more precisely.

Pro tip

  • Compare data from the previous step (seen in the Input 1 tab) to the data in the Results tab to see how many rows of data were removed. 

Visit our support docs to learn more about the step. 

Next lesson
Freight & Logistics
Retail & Ecomm
Automatically manage your CRM
Automatically update store inventory
Better, faster, more powerful reports
Custom metrics, anywhere
Ecommerce Marketing Flows
Ecommerce Operations Flows
Generate rich customer insights
Go beyond the limitations of spreadsheets
Intelligent search and email marketing
Manage unique products
Powerful, custom reporting
Quickly respond to low inventory
RevOps Use Cases
Set up triggered alerts (even complicated ones)
Support your Sales team
Use APIs without any code