We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

New to Alteryx - Filtering Issues

Groffia
5 - Atom

I am killing myself over something so simple.  I need to filter for multiple variables from a single field.  I'm Excel minded right now, so I'm just hoping to select the variables I am looking for in a specific column and the results will filter for me. 

 

Material Movement Type Code - I need to filter for the following codes:  101, 641, 941, 947

 

The basic function in a custom filter won't work: [Mtrl_Mvmnt_Typ_Cd] = ("101","641","941","947")

 

So what will work?  Any help would be greatly appreciated in my adolescent Alteryx state.

 

Thanks, Steve

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus

@Groffia,

 

Don't JUMP!  The solution is ....  IN

 

[Mtrl_Mvmnt_Typ_Cd] IN ("101","641","941","947")

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels
Top Solution Authors