Multiple filter

[kamal03]

Hi Alteryx family,

I want to filter out the column based on the sample data provided below.

I am using this formula:-!Contains([Name], "EventYear") but I want to filter multiple values using the single formula, I know I can use multiple not contain formulas like the one below:-

!Contains([Name], "EventYear") or !Contains([Name], "TEST") or !Contains([Name], "test1")

But I want to know if there is any easy method to do this.

Thanks in advance.

[ChrisTX]

One option attached

 

Chris

[Peachyco]

If it's a short list of values that you're filtering out, I'd put them in a Text Input Tool and Join with the main dataset. From that Join, I would pick the channel (L or R) where there are no successful joins. Like so:

EDIT: Just missed Chris' solution above. That would work better since it can handle partial matches.