Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

Alteryx Designer Desktop Discussions

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

Filter using first two characters

nicktekippe
8 - Asteroid

I need to filter this data to only the materials that begin with AR

nicktekippe_0-1661958024638.png

Any help would be appreciated.

2 REPLIES 2
DataNath
17 - Castor

Hey @nicktekippe, use a Filter tool with the following expression:

 

Startswith([MATERIAL], 'AR')

 

The results you want will come out of the top (True) anchor.

 

DataNath_0-1661958279781.png

binuacs
21 - Polaris

@nicktekippe Another way of doing this with the left function

binuacs_0-1661958559382.png

 

Labels