key word

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

Expression

Accepted answers

DataNath

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.

All comments

DataNath

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

Hey @ntudev,

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

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd

philipmannering

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

It appears I have provided a duplicate solution. Apologies.

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167