community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

filtering multiple fields

Meteor

hi can someone guide me as to how do I filter multiple fields?

 

I keep getting an error "Contains Requires 2 or 3 arguments. here is my filter expression".

 

Contains([F22],"Manual Check")
&&
!Contains([F23], "CSM","DC","MO-AO","PAY","Undefined","MO-ICF","MO-SOKO")       
&&
Contains ([F11], "null")

Highlighted
Asteroid

Hi @lancegoh1!

 

Your 2nd Contains statement has too many arguments. You should switch that to  "[F23] NOT IN ("CSM",...)".

 

Also, I am not sure if F11 is supposed to have NULL values or if "null" is the value, but the difference will change how you filter that field. If it is truly NULL values, then use isNull([F11]). Otherwise, your Contains statement should work.

 

I hope that helps!

-AD

Meteor

wow Thanks!

 

Regards,

Lance

Labels