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.
Solved! Go to Solution.
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?