Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
21 - Polaris

@greenman73 try the formula

 

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

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

Labels
Top Solution Authors