Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

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
20 - Arcturus

@nicktekippe Another way of doing this with the left function

binuacs_0-1661958559382.png

 

Labels