Start Free Trial

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

binu_acs
21 - Polaris

@nicktekippe Another way of doing this with the left function

binuacs_0-1661958559382.png

 

Labels
Top Solution Authors