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.
I have a table that contains a free-for-all field in which individuals can enter comments. These comments contain certain keywords that I'm trying to identify. I'm creating a custom filter expression using the IN function to generate a list, rather than create individual IF statements for each of the keywords. It seems like the traditional SQL wildcard identifier doesn't work with the alteryx IN function, so now I'm at a dead end for which Google has had no answers. Is this at all possible?
I thought so too at first and gave it at try to no avail. An example of the field in which I'm trying to isolate these keyword would be:
"This project is related to [keyword], for client x. [keyword2] is due by date x". I need alteryx to be able to identify which records have those keywords in that field and filter them. Hence why I need the wildcard functionality to be able to isolate the keywords.