Free Trial

Alteryx Designer Desktop Discussions

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

key word

ntudev
8 - Asteroid

is there a way to filter out anything that says 'no movement'? regardless of the numbers attached to it? i would only like to be left with ' Moved From'

 

no movement10
no movement30
Moved from54
no movement90
Moved from94
Moved from64
no movement80
no movement70
4 REPLIES 4
DataNath
17 - Castor
17 - Castor

Use a filter tool with the following expression:

 

!Contains([Field], ‘no movement’)

 

Replace ‘Field’ with whatever your column is called. What you want will come out of the top (True) anchor.

IraWatt
17 - Castor
17 - Castor

Hey @ntudev,

Easiest way to do this is with the filter tool using the does not contain option:

IraWatt_0-1660594467021.png

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

 

PhilipMannering
16 - Nebula
16 - Nebula

You can use the Filter Tool with the expression,

 

not contains([My Field Name], 'no movement')

 

It's case insensitive. Obvs replace [My Field Name] with your field.

PhilipMannering
16 - Nebula
16 - Nebula

It appears I have provided a duplicate solution. Apologies.

Labels
Top Solution Authors