Filter Tool to Remove Multiple Criteria

Hello Community,

I am running a pretty long formula and I am getting false positives due to garbage data entries. My problem is that I am not too familiar with the custom filter option on the Filter Tool.

I am looking to remove all entries with invalid data such as 99999999999, 8888888888, 7777777777...so on and so forth at the data entry point.

Thank you!!

FEscobar

Screenshot 2021-01-06 115521.png

Datasets

Accepted answers

pedrodrfaria

Hi @Fescobar

It is great that you were able to find the solution. For educational purpose and for other people with similar questions, see below for my attempt

Filter Tool:

[Field1] != '99999999999' and

[Field1] != '8888888888' and

[Field1] != '7777777777'

Let us know if your solution looks different.

Pedro.

All comments

Fescobar

Solution found.

pedrodrfaria

Hi @Fescobar

It is great that you were able to find the solution for your question.

One way you can do this is to this filter below:

[Field1] != '99999999999' and
[Field1] != '8888888888' and

[Field1] != '7777777777'

Pedro.

pedrodrfaria

Hi @Fescobar

It is great that you were able to find the solution. For educational purpose and for other people with similar questions, see below for my attempt

Filter Tool:

[Field1] != '99999999999' and

[Field1] != '8888888888' and

[Field1] != '7777777777'

Let us know if your solution looks different.

Pedro.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703