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

IF Statement "starting with ____"

sswift13
7 - Meteor

I am trying to create an IF statement that

 

IF [Part Prefix] begins with IL**** then "Illustrations" ELSE Null() ENDIF

 

However, I am not sure how to have the IF Statement look for data that starts with one/two letters and ends with random numbers.

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

If startswith([part prefix],"Il") then "Illustrations " else null() endif

 

 that should work

 

 cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
KateC
8 - Asteroid

After messing around with "if contains" and REGEX_MATCH for far too long, this post is the one that got me what I needed. Thanks!

Labels