Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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