---
title: Applying Row Filtration with Data Objects
description: "Data Objects are crucial for structuring and preparing data for presentation in Assette, and controlling which rows are included can significantly improve the precision and relevance of outputs. By using row-level filtration, users have flexible options to filter and transform…"
url: "https://learn.assette.com/docs/applying-row-filtration-with-data-objects/"
updated: "2025-04-26"
category: Developers / Developer Tools / Data Object Editor
---

# Applying Row Filtration with Data Objects

Data Objects are crucial for structuring and preparing data for presentation in Assette, and controlling which rows are included can significantly improve the precision and relevance of outputs. By using row-level filtration, users have flexible options to filter and transform rows either at the source or through transformations, offering fine-tuned control over their datasets.

![Applying Row Filtration with Data Objects 1](https://learn.assette.com/wp-content/uploads/2025/04/image-16-1024x434.png)

### Filtering Rows at the Source

Under the [Data Source Tab](https://learn.assette.com/docs/data-source-tab/) of the Data Object's [Design View](https://learn.assette.com/section/design-view/), users can add a **Row Filter**. This filter allows users to specify conditions that determine which rows are included, directly at the Data Block-Data Object interface. This proactive filtration ensures only relevant data proceeds through the remaining transformation and presentation pipeline, improving performance and manageability.

![Applying Row Filtration with Data Objects 2](https://learn.assette.com/wp-content/uploads/2025/04/image-17-1024x98.png)

### Row Transformations & Row Removal

Within the Row Transformation area, the **Row Removal** section has been redesigned for greater flexibility:

- **Never**: No rows are removed; all rows from the source are retained.
- **Always**: All rows matching the specified criteria are removed without exception.
- **If**: Rows are removed conditionally based on user-defined logic.

![Applying Row Filtration with Data Objects 3](https://learn.assette.com/wp-content/uploads/2025/04/image-19.png)

When the user selects "IF" the Condition text box appears, allowing the user to define custom logic using Assette's formula language. Additionally, users can choose whether the condition applies to the Current, Next, or Previous row, offering highly specific row removal capabilities.

This is especially powerful when working with complex data sets where certain rows must be excluded dynamically based on adjacent data or evolving business rules. For guidance on writing expressions, users can reference the [Expressions, Operators, & Functions](https://learn.assette.com/docs/object-editor-expressions/) documentation.
