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

filtering multiple fields

lancegoh1
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")

2 REPLIES 2
ADerbak
11 - Bolide

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

lancegoh1
7 - Meteor

wow Thanks!

 

Regards,

Lance

Labels