Filter Tool to Remove Multiple Criteria
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Solution found.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.