Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filter Tool to Remove Multiple Criteria

Fescobar
8 - Asteroid

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

3 REPLIES 3
Fescobar
8 - Asteroid

Solution found.

pedrodrfaria
13 - Pulsar

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
13 - Pulsar

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.

Labels
Top Solution Authors