Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Using a wildcard to capture multiple items in a field

RCS
7 - Meteor

Hi alteryx community,

 

Im having an issue writing an if statement using wildards. 

 

Lets say I have field entries with wave 1, wave 2, wave 3, wave etc.

 

If [Other] = "Wave*"

Then 1

Else 0

Endif

 

Im trying to use a wildcard or any other related function to capture anything that starts with "Wave" and end in a plethora of variable endings.

10 REPLIES 10
agcamig
5 - Atom

Thanks for this! How can I apply this to a set of numbers? Instead of 'abc-treatment' say my [field] initially should contain a specific set of numbers (13 bytes) but I would also need  to pick up anything more than the 13 bytes?

Labels
Top Solution Authors