Sort and exclude filter rows

Last updated: September 25, 2026Applies to current supported NIM releases

Shape the result

Control which rows survive duplicate or Boolean rules and the order in which NIM returns them.

First build the filter's record selection. Use the options here only when the resulting rows need a consistent sort, one row per repeated value, or removal by a Boolean flag. If you need to compare a value with another table, use a lookup instead.

Need	Control
Order rows by one or more columns	Ordering & Selection > Ordering
Keep the first row for each repeated value	Ordering & Selection > Only Include First
Remove rows where a Boolean field is true	Exclude > Exclude Rows For Which Column Equals True

Sort rows

1. Edit the filter and open Ordering & Selection.
2. In Ordering, set Direction to Ascending or Descending for the first sort column.
3. Set directions for additional columns if needed. Drag each Sort Handle to set the priority of the criteria.
4. Preview the result in Data with Filter, then select Save.

Sorting also decides which row is kept when you use Only Include First. Set the sort before testing duplicate handling if a particular row must win.

Keep one row from each repeated value

For example, a relation might return multiple contract rows for one employee, while the workflow needs one employee row.

1. In Ordering & Selection, select Only Include First.
2. Set Top Rows to the number of rows to keep for each repeated value, usually 1.
3. Select the column that identifies the repeated value.
4. Preview both a repeated and a unique value, then select Save.

Exclude rows marked by a Boolean column

Use this option when a source or calculated column already identifies rows to remove, such as an inactive_contract flag.

1. Open Exclude and select Exclude Rows For Which Column Equals True.
2. Select the Boolean filter column.
3. Open Data, select Filter, and verify that marked rows are absent before saving.

To subtract the result of another entire filter, see filter exclusions.