We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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
‎08-31-2022 08:01 AM

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

nicktekippe_0-1661958024638.png

Any help would be appreciated.

Reply
0 Likes
2 REPLIES 2
DataNath
17 - Castor
17 - Castor
‎08-31-2022 08:03 AM

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

Startswith AR filter.yxmd
Reply
0 Likes
binuacs
21 - Polaris
‎08-31-2022 08:09 AM

@nicktekippe Another way of doing this with the left function

binuacs_0-1661958559382.png

 

Filter_0831.yxmd
Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All