How to remove duplicates in one compound filter, from another compound filter?

Vaughn
Vaughn Altair Community Member
edited December 2021 in Community Q&A

I have a compound filter that identifies and shows me duplicates between two lists of data.

I want to remove those found duplicates from another compound filter. 

Is this possible? Is there an easier way to do this? 

 

In other words I only want the duplicated lines to show on one of the two compound filters I have. 

 

EDIT: Here is the compound filter that I want to remove the duplicates from if that helps. 

image

Tagged:

Best Answer

  • CPorthouse
    CPorthouse
    Altair Employee
    edited December 2021 Answer ✓

    I would take the formulas you used to create the individual filters and create a formula field that puts a yes/no value in the column that identifies the duplicates.  You can then create another filter to filter out the yes values.

Answers

  • CPorthouse
    CPorthouse
    Altair Employee
    edited December 2021 Answer ✓

    I would take the formulas you used to create the individual filters and create a formula field that puts a yes/no value in the column that identifies the duplicates.  You can then create another filter to filter out the yes values.

Categories