FILTER TOOL PARSE ERROR

Hi! It's me again trying to understand and explore Alteryx. Im very new to Alteryx and here's where I'm lost at. I need to filter column "EXCLUSION" and select 3 outcomes (E3, E2, E3 and BLANK or no value) kindly refer to screenshot below. How do I do that in custom filter please? I have a parse error or is my custom filter entirely wrong? THANKS!

Parse

Accepted answers

Sarreddy

@CathrinaJay

Can you try like this.

New Workflow1.yxmd

JamesCharnley

@CathrinaJay you still haven't used the IN function here for EXCLUSION. That part should read [EXCLUSION] IN ("E3","E2, E3", null()), not the equals.

All comments

JamesCharnley

Hi @CathrinaJay

If you want to filter for multiple values in one field like this in a filter, you'll need to use the 'IN' function instead of using equals. If you were to use equals, you'd need to use 'EXCLUSION =' for all of the values separately. Conceptual screenshot attached in the absence of data to use

CathrinaJay

wow! thanks! Im gonna have to try this

CathrinaJay

I have tried it already but it wont work. No error in this custom filter but no True value has come out. I wonder why. But when I try to put only [STATUS] = "P" and [EXCLUSION] = "E3" and [DUMMY] = "N" and [ACS_TRANSCODE] = "OVERMOTH" it works. But I need to filter the below in EXCLUSION column not just E3.

Here's the requirement I need in my filter tool:

Column STATUS - P

Column Exclusion - E3, E2,E3 and (Blank)

Column Dummy - N

Column Acs_Transcode - OVERMOTH

Sarreddy

@CathrinaJay

Can you try like this.

New Workflow1.yxmd

CathrinaJay

Thank you guys!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703