NIM

Exclude rows

Filters often return unwanted rows. If you cannot easily re-structure a filter to eliminate such rows, there are two ways to exclude them: by duplicate value or by Boolean value.

Some filters return unwanted duplicate rows. For example, suppose you want a de-duplicated list of all employees who have a contract in a HR500 test dataset. The filter below attempts to achieve this, but returns duplicate rows since some employees have multiple contracts:

2021-05-27_13-19-38.png

In this case, the Only Include First feature is the solution. Use it when you cannot easily re-structure the filter to achieve the desired results.

This feature can also be used to only partially exclude duplicate rows, which can be useful in certain edge cases.

  1. For the relevant filter, Edit a filter.

  2. Go to the Ordering & Selection tab.

  3. Select the Only Include First checkbox.

  4. Enter the number of Top Rows to keep. Typically, this is 1.

  5. In the dropdown, select the column whose duplicate rows should be excluded.

    2021-05-27_13-34-45.png
  6. Go to the Data tab.

  7. Click Filter to return the filter's output in the Result pane.

  8. Only the first row is kept. Duplicates have been excluded.

    2021-05-27_13-36-18.png
  9. Click Save.

In some cases, the rows you want to exclude are not duplicates, but rather indicated by a Boolean field. For example, a field indicating if a user has an inactive contract:

2021-08-13_15-20-04.png

In this case, the Exclude Rows feature is the solution.

  1. For the relevant filter, Edit a filter.

  2. Go to the Exclude tab.

  3. Select the Exclude Rows For Which Column Equals True checkbox.

  4. In the dropdown, select a filter column. For example, inactive_contract.

    2021-08-13_15-21-08.png
  5. Go to the Data tab.

  6. Click Filter to return the filter's output in the Result pane.

  7. The relevant rows have been excluded.

  8. Click Save.