Alteryx Designer Discussions

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

Formula Assistance

greenman73
6 - Meteoroid

I am new to Alteryx, especially how the coding works.  I am using the Filter widget.  I am trying to filter on one column which has a variety of data in it.  I want to filter out certain pieces of it.  

 

For example: [NAME] = "02-enterprise" which pulls this one, no problem, but i also want to pull 02-consumer from the same column but i cannot figure out the formula.

 

Any help is greatly appreciated.

 

Thank you in advance!!!

2 REPLIES 2
binuacs
16 - Nebula

@greenman73 try the formula

 

[NAME] IN ( "02-enterprise" ,"02-consumer")
greenman73
6 - Meteoroid

Thank you.  I used 'in' instead of 'IN'.  

Labels