How do you filter on a field based on the value?

[Dom]

Hello,

I need to exclude values from the output on a particular field. Ex. I need to exclude test users from the output. 

UID field can be either test, test1, etc.

[michael_treadwell · Accepted solution]

If you need to remove fields of the format test, test1, test2, ..., testN use Dynamic Select with 'Select via Formula'

!CONTAINS([Name], 'test')

If you need to remove rows from the data, use the Filter tool

[Dom]

I need to remove rows of data if 'Test' is in the UID field. Does the suggested expression work for a filter as well?

[MarqueeCrew]

yes

[Dom]

I used the expression in the filter but it only excludes the name and gender but not the row. See attachment

[jdunkerley79 · Accepted solution]

If you want to exclude the whole row use a filter tool: