Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Multiple filters using StartsWith

bui195
7 - Meteor

I'm trying to filter out data set with GL accounts that start with number 17 and 30 (GL accounts have 6 characters). So far I can only filter dataset with 17 GL or 30 GL. Can I write one formula that apply to both numbers? Thank you. 

3 REPLIES 3
ShankerV
17 - Castor

Hi @bui195 

 

Please try using the OR function.

ShankerV
17 - Castor

Hi @bui195 

 

One way of doing this, 

 

ShankerV_0-1684780579976.png

left(tostring([GL accounts]),2) = "17" OR
left(tostring([GL accounts]),2) = "30"

 

ShankerV_1-1684780599894.png

 

Many thanks

Shanker V

NMangera
10 - Fireball

@bui195 ,

 

if the data type is already a string, another approach is...


NMangera_0-1684780860805.png

 

Labels