Why does this filter not work?

[craigja]

Why does the below filter, not actually filter anything out?

[fund_status] != "MODEL-DEAD"
or [fund_status] != "DELETE"
or [fund_status] != "PROSPECTIVE"

[ChrisTX]

Guessing you should use AND (not OR)

You could also use something like this

[fund_status] NOT IN ("MODEL-DEAD", "DELETE", "PROSPECTIVE")

Chris

[binuacs]

@craigja Use the AND operator instead OR 

[fund_status] != "MODEL-DEAD"
AND [fund_status] != "DELETE"
AND [fund_status] != "PROSPECTIVE"

[ShankerV]

Hi @craigja 

Are you expecting the result like this.

Input was:

Many thanks

Shanker V

[craigja]

Figured it out - or rather I asked ChatGPT and it figured it out!

In Alteryx, you are using an "or" condition in your filter, which may not provide the desired results when filtering out rows based on multiple unequal conditions. In your current filter, if any of the conditions are true, the row will be included in the filtered data set, which may not exclude all of the undesired records. To fix the filter and exclude rows containing "MODEL-DEAD", "DELETE", or "PROSPECTIVE", you should use an "and" condition instead:

```
[fund_status] != "MODEL-DEAD"
and [fund_status] != "DELETE"
and [fund_status] != "PROSPECTIVE"
```

This way, you ensure that only rows where all three conditions are true (none of these fund statuses are matched) will be included in the filtered data.

[craigja]

Thanks for the answers though!  All makes sense now