This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
community Data Science Portal alteryx .com community Data Science Portal alteryx .com community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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
a month ago

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.

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

MarqueeCrew
19 - Altair
19 - Altair
a month ago

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.
Reply
Labels