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

Startswith functionality

GaurVitul
7 - Meteor

Hi all,

 

I have a list of items from which I need to find that starts with a particular word. I am trying the startswith function but not getting the desired results. 

 

For example, I need to find all products that start with Star - Star ABC, Star XYZ. However, I don't want products in my results like StarAA, StarCDB etc.

 

Am I using the right function for this requirement?

4 REPLIES 4
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @GaurVitul,

 

The StartsWith() function sounds like a good call, could you include some sample data with the product text and the outcome you'd like from those rows in your filter?

 

Regards,

Jonathan 

GaurVitul
7 - Meteor

Hi @Jonathan-Sherman 

 

Here is the sample data with input and desired output. 

GaurVitul
7 - Meteor

I used getword function and it worked. 

jarrod
ACE Emeritus
ACE Emeritus

Hi @GaurVitul ,

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

As the original author, you also have the ability to mark replies as solutions! Going forward, I’d encourage you to identify the solution or solutions that helped you solve your problem, as it's a big help to other community members. Learn more about Accepted Solutions here.

Thank you!

Labels