Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

support with "in" function


hi all


I am trying to use the "in" function to search for a string in a list of strings (e.g.: search for 'a' in ('a','b','c')) and it works if I hard code the values, but does not work if the values are stored in a variable (column).


Let's say the data looks like this:

[Search]  |  [List]

'a'            |  'a','b','c'


If I configure the formula as follows --> [Search] in ('a','b','c') --> it works, but if I do --> [Search] in [List] --> it does not work (tried with and without the " ' "). Why is that?


p.s.: I know I could use contains([List],[Search]), but I am interested in why the 'in' function does not work...


Thank you.


Alteryx will be treating the [List] field as one value.


The expression will treat each entry separated by a comma as a whole value, as opposed to the values within those entries. It's not dynamically looking into the values for a comma separate list as well (god that's horrible to try and write, but hopefully makes sense?).


As you say Contains() will work in your scenario, or please have a look at the dynamic formula as part of the CReW macros here


thank you, Joe