Alteryx Designer Discussions

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

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!


IF Statement "starting with ____"

6 - Meteoroid

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.

19 - Altair
19 - Altair

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


 that should work





Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.