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.
In my daily report there is a column "Notes". I want to eliminate all those line items where the comments in the "Notes" starts with "Open Issue". I am new to Alteryx with very limited knowland would really appreciate if anyone can assist me on this.
Hey @rdas040, one of the String functions built into Alteryx is Startswith(), which does exactly what it says on the tin and looks at the start of the string for whatever target you provide (in your case, "Open Issue"). For your use, you can therefore use this function within a filter with the following expression:
!StartsWith([Notes], 'Open Issue')
In Alteryx, we use the exclamation mark to indicate 'NOT' and therefore what this expression is saying is: [Notes] does not start with 'Open Issue'.
Now when this is checked, it's either true - doesn't start with 'Open Issue', or false - does start with 'Open Issue'. Therefore, you are only interested in what comes out of the top (True) anchor of the Filter tool, as shown below.
Please let us know if you need any further clarification or if this doesn't answer your request!
@rdas040 , you can accomplish what you need by using filter tool, just add filter tool after your input and check the custom filter radio button and add below condition in it, all the Notes that begins with "open issues will be moved to False output. Pleas take care of the case of the string.