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.
Filtering Rows at the Source #
Under the Data Source Tab of the Data Object’s 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.
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.
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 documentation.