Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Formula Assistance

greenman73
7 - Meteor

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
20 - Arcturus

@greenman73 try the formula

 

[NAME] IN ( "02-enterprise" ,"02-consumer")
greenman73
7 - Meteor

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

Labels