Alteryx Designer

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

filtering multiple fields

Highlighted
7 - 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
9 - Comet

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

Highlighted
7 - Meteor

wow Thanks!

 

Regards,

Lance

Labels