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!

SOLVED

IF Statement "starting with ____"

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

MarqueeCrew
19 - Altair
19 - Altair

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 reboot. Order shall return.
Labels