Multiple filter

Question

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.

Values need to filter.xlsx

Peachyco · Answer

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.

ChrisTX · Answer

One option attached

Chris

Multiple filter.yxmd