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